Toolbars
 

Trap the workbook open and activate events to hide the toolbars, and in the
workbook deactivate event restore them to their original status.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Sheldon" wrote in message
...
How do remove toolbars (specifically Standard, Formatting, and Control
Toolbox) and Formula Bar, Status Bar, Gridlines, and Row and Column
Headers
either in code or manually, in such a way that the operation does NOT
affect
other workbooks?

Thanks