Custom Menus in Personal.xls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
I have a personal.xls which was created in a previous version of Excel by
Click to expand...
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
Click to expand...
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.
 
Tom said:
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.
Click to expand...
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.
 
Back
Top