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

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.

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

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.
.