Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
RzB RzB is offline
external usenet poster
 
Posts: 27
Default Saving VBA Toolbar Customisation

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Saving VBA Toolbar Customisation

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

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel startup customisation Allan Boardman Excel Discussion (Misc queries) 2 July 24th 06 01:19 PM
saving change in toolbar James Excel Worksheet Functions 1 February 10th 05 07:50 PM
saving toolbar choice Excel Discussion (Misc queries) 2 December 27th 04 08:22 PM
Customisation of Chart Dialog Jon Peltier[_4_] Excel Programming 0 October 26th 03 01:13 AM
saving toolbar buttons on custom toolbar Paul James Excel Programming 12 August 6th 03 08:28 AM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"