View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default Show no toolbars in specific book

Michael

As you are saying "I understand that the user can simply go to
View--Toolbars", I am presuming you want 'Full screen view' If not you will
need to explicitly hide all the commandbars in the window. The former could
be done in the Workbook_Open() event. (To implement this right click on the
Excel Icon at the top left of the window and select view code... and paste
in here.

Private Sub Workbook_Open()
Application.DisplayFullScreen=True
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"michaelberrier" wrote in message
ups.com...
I manage a workbook that is used by lots of people, and therefore the
nuts and bolts are protected and locked. I would also like to hide all
the toolbars when this book opens. I understand that the user can
simply go to View--Toolbars to see them, but most of these people
won't have any reason to do that and I'd like to clean this interface
up as much as possible.

I've seen this done before, but I can't find the option(s) to make it
happen.

Thanks.