View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Saving VBA Toolbar Customisation

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.

--
sb
"RzB" wrote in message
...
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