Saving VBA Toolbar Customisation

  • Thread starter Thread starter RzB
  • Start date Start date
R

RzB

I open Excel and then open the VBA Editor.
Then I customise the VBA Editor toolbar.
What do I need to do to make sure that
customisation is saved so that it returns when
next open Excel/VBA Editor.
Many thanks,
Roy
 
RzB,

The Toolbars (complete with customization) is saved to a special file
(*.xlb) when you close Excel.

It will only be lost if Excel crashes.
Suggest that after you get the toolbars where you like them, close Excel
and than reopen Excel.
 
Hmm... Yes that's sort of what I expected. Tried that and it
does not work. It's OK for excel but not the VBA editor.
Perhaps I need a reinstall.... Hmmm...
Thanks,
Roy
 
Back
Top