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
|