Menu Options

  • Thread starter Thread starter Kevin Hill
  • Start date Start date
K

Kevin Hill

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).
 
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
Click to expand...
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
Click to expand...
converting your modules into an Excel Add-in is one sure-
fire way of ensuring that the menu items remain and work
as planned.
 
Back
Top