formatting palette "flys off screen"

[cfbdhb]

In "normal" view, when opening the formatting palette, it "flies off the screen" to the bottom (a quick shadow is visible).

When viewing in "full screen" view, the formatting palette is visible

but "full screen" is not always desirable.

The formatting palette is not being captured by the dock,

because when the dock is moved to the side the "fly-off" is still to the bottom.

 

[JE McGimpsey]

In "normal" view, when opening the formatting palette, it "flies off the
screen" to the bottom (a quick shadow
is visible).
When viewing in "full screen" view, the formatting palette is visible

but "full screen" is not always desirable.

The formatting palette is not being captured by the dock,

because when the dock is moved to the side the "fly-off" is still to the
bottom.

How do I retrieve the formatting palette?

[/QUOTE]

One frequent cause for this is having repositioned the palette with the
screen set to a higher resolution. You can try setting it to the higher
resolution, repositioning the palette, then switching back.

If that doesn't help. Switch to the Visual Basic Editor by typing
Opt-F11. Open the Immediate Window by typing CMD-g. Type or paste these
two lines into the Immediate Window, following each with Return:

Application.Commandbars("Formatting Palette").Top = 100
Application.Commandbars("Formatting Palette").Left = 100

Type Opt-F11 to return to XL. Your formatting palette should now be
near the upper left corner of the screen where you can grab and
reposition it.

 

[Chas Fisher]

I have the same flying problem. Thanks for the VBE tip, but that
didn't do the trick for me. It still flies off. My screen resolution
is set for the highest it can go and the window is still not visible.
Any more tips?

thanks

chas

 

[JE McGimpsey]

I have the same flying problem. Thanks for the VBE tip, but that
didn't do the trick for me. It still flies off. My screen resolution
is set for the highest it can go and the window is still not visible.
Any more tips?

One thing to try would be to, with XL closed, delete

~:Library:Microsoft:Excel Toolbars (11)

(where ~ is your home folder).