Keyboard shortcut for formatting palette?

[Brian Abbott]

I'm running Office 10.1.4 on an Emac with OS 10.3. I would like to set up a
keyboard shortcut for showing/hiding the formatting palette. I did this in
Word by using the Customize command in the Tools menu. There I found a
command called "viewformattingpalette" and the rest was easy.

In Excel I've searched and searched and cannot find this command, nor can I
find any other way to set up a keyboard shortcut for it. I even tried to
achieve this goal by setting up a macro involving the formatting palette
button on the toolbar, but this doesn't seem to work either.

Anyone have any thoughts on this???

Thanks in advance, --Brian Abbott

[JE McGimpsey]

In article <BC723B39.97B%last...@vtusa.net>,
Brian Abbott <last...@vtusa.net> wrote:

The View/Formatting Palette didn't make it into the exposed commands in
XLv.X (probably since it's a MacXL-only feature).

However you can certainly accomplish a toggle. Put this macro in your
Personal Macro Workbook and assign it to a keyboard shortcut or a
toolbar button:

Public Sub ToggleFormattingPalette()
With Application.CommandBars("Formatting Palette")
.Visible = Not .Visible
End With
End Sub

[Brian Abbott]

On 3/8/04 3:32 PM, in article
jemcgimpsey-A619...@msnews.microsoft.com, "JE McGimpsey"
<jemcg...@mvps.org> wrote:

Thanks! That worked perfectly. --Brian