Menu Options
 

Hi,

I know this is basic stuff but how do I get a newly added
menu item to remain there after closing Excel ? I
currently add a menu item to the file menu in Excel and
want it to remain there permanently.

Thanks for any help that I get.

Kevin

Menu Options
 

Hi Kevin,

Have you added this menu item via the Tools-Customize medium? I have tried doing so, and the menu remains intact when I open another Excel session, although the macros linked to those may not.

More advanced users may have a more elegant solution, but converting your modules into an Excel Add-in is one sure-fire way of ensuring that the menu items remain and work as planned.

Please let me know how you go,

SuperJas.

Menu Options
 

That should be the normal behavior. The syntax has a temporary argument

expression.Add(Type, Id, Parameter, Before, Temporary)

Do you have temporary=True. If you do, make it false or don't include it
(the default is false).

--
Regards,
Tom Ogilvy



"Kevin Hill" wrote in message
...
Hi,

I know this is basic stuff but how do I get a newly added
menu item to remain there after closing Excel ? I
currently add a menu item to the file menu in Excel and
want it to remain there permanently.

Thanks for any help that I get.

Kevin

Menu Options
 

Hi SuperJas,

I actually got around it by copying the excel file
containing macros to the xxlstart folder in the microsoft
office / office folder it now runs everytime on opening.

I think your tools - customize option will be better to
use going forward as I would not want too many files in
xxlstart.

Thanks for your help.

Kevin



-----Original Message-----
Hi Kevin,

Have you added this menu item via the Tools-Customize
medium? I have tried doing so, and the menu remains intact
when I open another Excel session, although the macros
linked to those may not.

More advanced users may have a more elegant solution, but
converting your modules into an Excel Add-in is one sure-
fire way of ensuring that the menu items remain and work
as planned.

Please let me know how you go,

SuperJas.
.