BKeegan said:
I'm having the same problem. While moving some toolbars the Formula Bar
shifted to the left side of the screen where the grab bar is not accessible.
Very weird - I can't reproduce that.
I've tried both the methods described by JE Gimpsey and neither work for me.
That's because you have a *different* problem than the original poster,
whose Formula bar's grab handle was accessible, but the bar extended off
the *right* side because it had been extended too far. Resetting the bar
shortened it to the original size.
To fix the formula bar off the *left* side, so that the grab handle is
inaccessible, use one of these three techniques:
1) Shift your monitor to a higher resolution so that the entire bar is
visible, drag it back to the middle of the worksheet. Reset your
resolution. Position as desired.
2) If you don't have toolbar customizations you want to keep, then, with
XL *closed*, trash the
~:Library
references:Microsoft:Excel Toolbars (11)
file (where ~ is your home directory). Restart XL.
3) Type Opt-F11 to open the Visual Basic Editor (VBE). Type or paste the
following, each line followed by a Return:
Commandbars("Formula Bar").Left = 100
Commandbars("Formula Bar").Top = 100
Type Opt-F11 to go back to XL. Position the bar as desired.
If you want to keep the Formula Bar in place, you can use this technique:
http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html
Two comments:
1) Good netiquette dictates that when a reply is bottom posted, your
further reply should be bottom posted, as well. That prevents having to
skip back and forth in the message to see what you're referring to when
you write "me too".
2) You can find the methods above posted many times, in various forms,
by searching Google Groups:
http://groups.google.com/advanced_group_search
putting in appropriate search terms, and using "*mac.office*" in the
Group input box.
