Formula bar off screen to left

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JeanLeRouge - 24 May 2007 11:45 GMT

Hi when I open Excel and activate the Formula bar it opens with the left hand
end off screen which means I cannot move it to dock it properly. Any ideas?

Signature

JonR

Reply to this Message

JE McGimpsey - 24 May 2007 12:15 GMT

> Hi when I open Excel and activate the Formula bar it opens with the left hand
> end off screen which means I cannot move it to dock it properly. Any ideas?

One way:

Type Opt-F11 to enter the Visual Basic Editor (VBE). Type CMD-g to open
the Immediate Window. Type or paste this line into the Immediate Window,
followed by Return:

CommandBars("Formula Bar").Left = 100

Type Opt-F11 to return to XL.

An alternative (if you don't have toolbar customizations that you want
to save):

With XL closed, delete the

~:Library:Preferences:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory).

Reply to this Message

JeanLeRouge - 24 May 2007 12:33 GMT

Thanks very much - that worked perfectly.

Signature

JonR

> > Hi when I open Excel and activate the Formula bar it opens with the left hand
> > end off screen which means I cannot move it to dock it properly. Any ideas?
[quoted text clipped - 17 lines]
>
> file (where ~ is your home directory).

Reply to this Message

Mac Forum / Applications / Excel / May 2007

Formula bar off screen to left