Custom Menus in Personal.xls
 

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

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

Custom Menus in Personal.xls
 

Tom Ogilvy wrote:
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.

Thanks Tom, I just finished the macro to make them be added during the
Workbook_open event, works a treat.

--
Guig
GSF600SY Bandit - It's blue you know.
CBFA #1

Oh for the wings of any bird, other than a battery hen.