Hide toolbars/Workbook elements

[Jason W]

How can I make it so if anyone opens a particular workbook all they will see
is the spreadsheet and none of the toolbars, tabs, etc. Everytime I try to
do it I end up hiding the elements on anything in Excel I open, which is the
exact opposite of what I want.

 

[Ron de Bruin]

Hi Jason

Start here
http://www.rondebruin.nl/menuid.htm

Run the code in this two events in the Thisworkbook module

Private Sub Workbook_Activate()
'Your code to change Enabled to False
'Or the name of your macro
End Sub

Private Sub Workbook_Deactivate()
'Your code to change Enabled to True
'Or the name of your macro
End Sub

 

[Jason W]

Awesome! Just what I needed. Thanks a lot for the reply.