How to make the Toolbar Invisible through VBA
 

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

--
Message posted from http://www.ExcelForum.com

How to make the Toolbar Invisible through VBA
 

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

-------------------


--
Message posted from http://www.ExcelForum.com

How to make the Toolbar Invisible through VBA
 

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).


---
Message posted from http://www.ExcelForum.com/