how to disable the formula bar using vba in excel 2016

So if designing for Windows and Mac, you will need to identify which platform is used and adapt the code accordingly. They will not work on a Mac, only on Windows.But the key points to note about the Windows API codes are: As this is complicated stuff, I will not go through it in detail here. These are where the VBA code makes use of functions which are not part of Excel, but part of the main Windows application. Of the three solutions, two of them rely on Windows API calls. As we can control this functionality, it may be better to control it rather than hide or disable it.

Therefore, it might be useful to hide the close button in this scenario.īy default, the close button will unload a UserForm, but it can be adapted to have a custom close procedure. If the user closes a progress bar, they may not know when the macro has finished running, or how long is left. However, there are some circumstances where we may want to break this general rule.

With this in mind, I would say that generally the close button should not be hidden or disabled. Therefore you should be asking yourself why you want to hide the close button at all. It doesn’t matter which country the user is in or what language they speak, it is a universally understood icon to close a window. Therefore, based on their experience of other applications, all users already know what the cross should do. Pretty much every application uses a cross at the top right corner to close a window. The close button is a recognized part of the Windows environment. To hide, or not to hide, that is the questionīefore we start looking at the three options, I want to cover the most critical question of all: should we hide a UserForm’s close button? If you are thinking about the same thing, then this post will give you the answers you’re looking for. I managed to identify three options for achieving this. While working on a project recently, I thought about hiding the close button which is at the top of the VBA UserForm.

How to disable the formula bar using vba in excel 2016