Custom Menus in Personal.xls
If the personal.xls had the menu created in xl95 or earlier, you would see
this behavior. You can not make permanent changes to these menus unless you
take the file back to xl95 and use the menu editor.
--
Regards,
Tom Ogilvy
"Guig" wrote in message
...
I have a personal.xls which was created in a previous version of Excel by
someone else. This personal.xls has a custom menu in it and I am trying to
add a new item to it.
I go through the Customise option, add the menu item etc, and point it at
the new macro and save the personal.xls. I then close down Excel and
re-launch it, and my menu item has vanished. I've even looked at coding the
AutoOpen event to add the item programatically but haven't had a lot of time
to play with it.
Am I doing something stupid (probably)?
Guig
|