How to make the Toolbar Invisible through VBA

  • Thread starter Thread starter Atif Akbar
  • Start date Start date
A

Atif Akbar

Hi,

I Wanna make some Toolbars invisible as User starts using my exce
sheet. I also want to make tab sheet invisible.

Can anyone help me out of this

Thank
 
Hi Atif,

You can uese macro recorder.
Here is a code generated by macro recorder.


Code
-------------------

Sub Macro1()
'
' Macro1 Macro
'Recorded : 2003/12/11 User : Colo the VBA Guy
'

'

Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Control Toolbox").Visible = False
Application.CommandBars("Standard").Visible = False
ActiveWindow.DisplayWorkbookTabs = False
End Sub
 
One word of warning:
The *hidden* toolbars will still be hidden when the user opens a
different workbook. Most users like to have their *favorite* toolbars
visible by default and would be irritated to have to *rebuild* their
preferred set.

To remedy this, you should return to visibility all items you have
hidden. Do this in the Workbook_Close event.

You may also hide all toolbars with
Application.DisplayFullScreen=True

Then reverse this as you close the wbk (Workbook_Close event).
 
Back
Top