Hide toolbars/Workbook elements
 

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.

Hide toolbars/Workbook elements
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jason W" wrote in message ...
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.

Hide toolbars/Workbook elements
 

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

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jason W" wrote in message ...
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.