Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBEditor toolbars
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBEditor toolbars
vbe setting saved in registry here i think. should be automatic
HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\UI maybe permissions problem? you can check with regedit.exe "Brettjg" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBEditor toolbars
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 "Homey" wrote: vbe setting saved in registry here i think. should be automatic HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\UI maybe permissions problem? you can check with regedit.exe "Brettjg" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
losing modules, and user forms in VBeditor | Excel Programming | |||
toolbars | Excel Discussion (Misc queries) | |||
Can any one help me out vbeditor for excel | Excel Programming | |||
Please Help, No Toolbars in my view-toolbars! | Excel Programming | |||
Project stays in VBEditor when workbook is closed | Excel Programming |