View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Colo[_19_] Colo[_19_] is offline
external usenet poster
 
Posts: 1
Default 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