when sheet is active hide toolbar

[kalpeshpatel]

my workbook contain 2 sheet


sheet 1 name ("Bill")

sheet 2 name ("Data")


i need a macro when sheet 1 ("Bill") is active to hide menubar & other toolbar

otherwise menu bar is unhide

 

[Luke M]

Will this work for you? Right click on sheet tab Bill, view code, paste these 2 macros in.

[pre]

Private Sub Worksheet_Activate()
Dim cb As CommandBar

On Error Resume Next
With Application
.DisplayFullScreen = True
For Each cb In .CommandBars
cb.Visible = False
Next cb
End With
On Error GoTo 0

End Sub

Private Sub Worksheet_Deactivate()
Application.DisplayFullScreen = False
End Sub

[/pre]

 

[prasaddn]

Hi Kalpeshpatel..


In fact the same question i remember you had posted for which Luke M provided the below link..


http://www.ozgrid.com/VBA/toolbar-remove-restore.htm


You can also look into it as well..


Regards,

Prasad DN

 

[kalpeshpatel]

thank wondering the answer


thanks again for help