That works great! One thing, though. The Full Screen option moves my
sheet tabs down below the task bar if it doesn't autohide, and I can
just hear the users screaming already if they can't see the whole tab.

That said, I guess it would be better to write the code just to hide
and/or disable the other toolbars in just this book. Some generic code
in that direction would be appreciated.

Thanks again.

Nick Hodge wrote:
Michael

Try this

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFullScreen = False
End Sub

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


"michaelberrier" wrote in message
oups.com...
The full screen looks like a good idea, but it applies that attribute
to any workbook I open after that. Is there a way to turn that on for
only that workbook? I tried a Workbook_Close sub but that did nothing.

thanks
Nick Hodge wrote:
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.