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