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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top