You go to View-ToolBars - Customize and then just drag-and-drop the
toolbars to any place outside the toolbar area and they will be removed. Thsi
will be saved in your xlb file and will be default for any worksheet you
open. If you want it done just for a single workbook - you need to create a
macro that runs when you open this workbook and removes the commanbar.
Use Application.CommandBars("Main Menu").Delete to remove a command bar.

Inbar.

"Sheldon" wrote:

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