Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Location of Hidden Toolbars?
In an Excel application I am developing (XL2002 on Win XP Pro), I hide
all of the toolbars displayed on the screen and leave only the Worksheet Menu Bar. Ideally, I'd like to freeze the position of all the toolbars before I hide them, then unfreeze them when they are revealed again. However, if the user moves the Worksheet Menu Bar while all the other ones are hidden, they appear rearranged when all of them are revealed. I looked at the CommandBar object, but couldn't find a property or method that would solve this problem. I tried the following when revealing the toolbars, but that didn't work as planned: Application.CommandBars("Worksheet Menu Bar").Top = 0 Does anyone know how to fix this problem? Thanks, - Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Location of Hidden Toolbars?
However, if the user moves the Worksheet Menu Bar while
You can prevent that: CommandBars("worksheet menu bar").Protection = msoBarNoMove You'd want to reset it to msoBarNoProtection on exiting. -- Jim "Bill P" wrote in message oups.com... | In an Excel application I am developing (XL2002 on Win XP Pro), I hide | all of the toolbars displayed on the screen and leave only the | Worksheet Menu Bar. Ideally, I'd like to freeze the position of all | the toolbars before I hide them, then unfreeze them when they are | revealed again. | | However, if the user moves the Worksheet Menu Bar while all the other | ones are hidden, they appear rearranged when all of them are revealed. | I looked at the CommandBar object, but couldn't find a property or | method that would solve this problem. I tried the following when | revealing the toolbars, but that didn't work as planned: | | Application.CommandBars("Worksheet Menu Bar").Top = 0 | | Does anyone know how to fix this problem? | | Thanks, | | - Bill | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Location of Hidden Toolbars?
Thanks, Jim. It works correctly now.
- Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
How to fix the toolbars location? | Excel Discussion (Misc queries) | |||
How do I freeze more than one location on my worksheet? | Excel Worksheet Functions |