Thanks Tom
Do you know what the code would be to do that?
I'm not sure how to refer to the different toolbars in vba.

thanks
-----Original Message-----
There is no applying. You have to write the code in the
appropriate events
to loop through all the toolbars and set the visible
property to false
(except commandbars 1 and 2 which have to be disabled),
and then restore
them when appropriate.

--
Regards,
Tom Ogilvy

"POPPY" wrote in
message
...
Hello

How can I make all the toolbars & menu bars disappear
when
I open a particular workbook, but re-appear when the
workbook is closed?

I'm not sure if it's possible to do this for one
workbook
or whether it has to apply to the whole application.
Applying to an individual workbook would be good.

thanks


.