Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web toolbar moves
I am using Office 2003 on Windows XP.
I have noticed a certain behaviour that has become a real annoyance which is as follows: I routinely have the Web toolbar switched on in Excel. When I run a macro, and it doesn't seem to matter which macro or what the program is doing, the Web toolbar moves. If it is in the third row of toolbars, it moves down a row, leaving a huge gap in my toolbars. If already at the bottom, it actually moves down again so that it is the only toolbar on the bottom row - even though there is plenty of space for it where it originally was. This is very annoying since it consumes screen real estate and I have to rearrange my toolbars after every program run. Does anyone know what is causing this and how to fix it? Thanks much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web toolbar moves
Try this at the start of your code:
Application.CommandBars.DisableCustomize = True and at the end: Application.CommandBars.DisableCustomize = False HTH, Bernie MS Excel MVP "XP" wrote in message ... I am using Office 2003 on Windows XP. I have noticed a certain behaviour that has become a real annoyance which is as follows: I routinely have the Web toolbar switched on in Excel. When I run a macro, and it doesn't seem to matter which macro or what the program is doing, the Web toolbar moves. If it is in the third row of toolbars, it moves down a row, leaving a huge gap in my toolbars. If already at the bottom, it actually moves down again so that it is the only toolbar on the bottom row - even though there is plenty of space for it where it originally was. This is very annoying since it consumes screen real estate and I have to rearrange my toolbars after every program run. Does anyone know what is causing this and how to fix it? Thanks much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Toolbar verses Control Toolbar | Excel Discussion (Misc queries) | |||
Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
Tab key moves | Excel Discussion (Misc queries) | |||
Placing a toolbar and it moves | Excel Discussion (Misc queries) | |||
saving toolbar buttons on custom toolbar | Excel Programming |