Custom Menu - lunching local macro (97 vs 2000)

P

Paula Sagui

I had a Excel 97 work book whihc included several macros.
I added these macros to the "tools" menu. These options
only appered on the tools menu when the work book containg
the macros was opened and would always correctly launch
the local macro no mater how may times I did a "save as".

However 2000 treats custome menus diferently. When adding
macros to a menu, the become perment and always show up
even when the work book containg the menu is not opened.
Choosing the macro from the menu causes Excel to atemp to
open a specfic workbook looking for the macro to execute.

I have two problems. First I liked the old behavior
beter, now if I do a save as of teh workbook continng the
macro or move the origional work book, Excel can't find
the macro.

Second, I've saved my 97 wrokbook as Excel 2000. The
menus behave as they did in the past, correctly launching
the macro local to the work book. However, I can not
permently alter the menu to remove or change the macro
excuted. Changes apear to be made when I customize, but
then I save the work book, get out and reopen, only to
find my menu assignments as tehy origionaly were.

Any one find a way around this?

Thanks!
 
D

Dave Peterson

I think the best way to handle customized menus is through code.

You add them when your workbook opens and delete them when the workbook closes.

If you like this idea, you can steal a very nice shell at John Walkenbach's
site. It's called MenuMaker.

http://j-walk.com/ss/excel/tips/tip53.htm
 
Top