I am using, Microsoft Excel 2000, Tools-Customize-Commands to Create New
Menu. When save, reopen the file, the new Menu loss.
How to set permanent menu ?

Don't try to make it permanent.

Add some code to a workbook that creates it when the workbook is opened and
deletes it when the workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

moon wrote:

I am using, Microsoft Excel 2000, Tools-Customize-Commands to Create New
Menu. When save, reopen the file, the new Menu loss.
How to set permanent menu ?

--

Dave Peterson

Thank Dave
Currently, I am using "Add some code to a workbook that creates it when the
workbook is opened and
deletes it when the workbook is closed".



"Dave Peterson" wrote in message
...
Don't try to make it permanent.

Add some code to a workbook that creates it when the workbook is opened
and
deletes it when the workbook is closed.

For additions to the worksheet menu bar, I really like the way John
Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

moon wrote:

I am using, Microsoft Excel 2000, Tools-Customize-Commands to Create
New
Menu. When save, reopen the file, the new Menu loss.
How to set permanent menu ?

--

Dave Peterson