VBEditor toolbars

  • Thread starter Thread starter Brettjg
  • Start date Start date
B

Brettjg

I spent about an hour making something meaningful out of VBE toolbar and
MZTools toolbar. Closed Excel. Then I even saved my office settings (2003)
and when I reopen Excel the toolbars are all back to default (for the second
time). When I change toolbars around in Excel the changes stick, but not in
the VBE. Is there a reason for this or something else that has to be done?
Thanks, Brett
 
vbe setting saved in registry here i think. should be automatic

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\UI

maybe permissions problem? you can check with regedit.exe
 
Hi Homey
Thanks for your response. In fact it turns out that all I have to do is save
the PERSONAL.xls book to keep the new settings (unlike Excel which
automatically stores them in XLB). It's a bit odd though because there's no
prompt to save the file when you close down Excel after you've changed some
settings. Regards, Brett
 
Back
Top