Saving Changes to a Command Bar.

  • Thread starter Thread starter Ken Valenti
  • Start date Start date
K

Ken Valenti

I have a macro that adds a Command to the Worksheet Menu Bar in Excel.

Application.CommandBars("Worksheet Menu Bar").Controls.Add(msoControlPopup)

When excel is shut down and restarted - the Command is still there - which
is what I want.

However, on some peoples machines - the Command goes away after closing Excel.

Do I need to designate temporary:=false (the default is false)

or is there an option Excel that can be changed?
 
Normally toolbar settings are saved when Excel quits. One explanation for
your toolbar settings not persisting is if user had two instances open, the
instance with your settings is closed followed by an instance which did not
have the settings.

Of course the settings might have been removed for one reason or another, eg
manually, by code or as you have noted if the Temporary setting was true.

Normally your addin or wb should add the buttons in the open event if they
did not exist, many also prefer to remove them in the close event.

Regards,
Peter T
 
Back
Top