Thanks very much, Jon.
I'm intruiged by "tool-bar customizations" and will
remember that sheet _deactivate is available!

Thanks/Cheers!

"Jon Peltier" wrote:

Toolbars do not reside with a worksheet, and with the exception of
attached custom toolbars, they do not reside with workbooks. They are a
part of the Excel Application. Also, built-in toolbars and menus cannot
be deleted, only hidden. I suspect your VBA just went and hid them.

Ron's suggestion to hose your .xlb file is okay if you don't have
toolbar customizations, since those are stored in the .xlb file (and not
in a format that ordinary humans can alter). It would be better to go
back into the VB Editor and restore what you hid.

If you want to hide menus and toolbars when a certain sheet is active,
you should hide them in that sheet's _Activate event, but don't forget
to save the list of hidden elements so you can restore them in that
sheet's _Deactivate event.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



tbd wrote:
Greetings,
I used VBA to remove menu and tool bars from the first sheet of an
.xls I'm developing, but managed to change Excel's defaults such that when
simply launching excel, the menu-bar is missing!

Does Excel use a configuration text-file I can change with notepad?

Note: I can open Help via the code-page (right-click on 'sheet1'
view code) but can't change worksheet properties there. I can get to
worrksheet menu-bar by opening my VBA code, it runs code to show menus,
though, my attempts to reset default properties have failed.

Thanks/Cheers!