Howard -

I wonder if that workbook not only had code to create the customized
menus, but also has customized menus attached to it. Tools menu
Customize Attach button.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Howard Kaikow wrote:
I've been playing with a workbook that includes code that saves and restores
the user's Excel environment, e.g., by hiding toolbars and particular items
in the Excel menu, then restoring the environment when the macro completes.
That's fine, I've done the same thing myself.

For my purposes, I've removed that code and tried to use Tools |Customize to
reset the workbook menu back to Excel's defaults.
However, if I save, close and re-open the workbook, I find that the settings
do not stick and revert to the customized settings that had been created by
the macro code.

Why aren't the settings sticking when I reset the menus?

The workbook was originally created with Excel 97, and I am using Excel
2002, could that be the problem?

I guess that I could write workbook_open code to remedy the situation, but
that should not be necessary, should it?