Nov 30 2020 03:10 AM
Nov 30 2020 05:40 AM
Open the Visual Basic Editor by pressing the key combination Alt + F11.
The Excel objects of all open workbooks are displayed in the Project Explorer of the Visual Basic Editor. If the Project Explorer is not visible, you can display it with the key combination Ctrl + R.
You can select a module sheet in the project explorer. In the Project Explorer, double-click the name of the appropriate module sheet. The module sheet is then activated and you can insert the code of the macros here.
If you have inserted the code in a module, you can exit the Visual Basic Editor again by pressing the key combination Alt + Q. Alternatively, you can execute the command sequence File> Close and Return to Microsoft Excel in the menu.
Here's how to start the macro and hide the status bar
In order to hide the status bar you have to start the macro Status bar hide. Press the key combination Alt + F8 to open the Macro dialog box. Click here with the left mouse button on the Status bar_Hide macro and then on the Execute button on the right.
-------------------------------------------
Copy this VBA Code into the module:
Option Explicit
Sub Hide_niko_bar ()
Application.DisplayStatusBar = False
End Sub
Sub Show_lino_bar ()
Application.DisplayStatusBar = True
End Sub
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Dec 01 2020 12:25 AM
Dec 01 2020 12:56 AM