VBEditor toolbars

[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

 

[Homey]

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

 

[Brettjg]

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