toolbar customization

[Sam Bays]

533 MHz Power PC G4 384 MB SDRAM

MAC OS X 10.3.3

Office X: Excel 10.1.5 (Service Release 1)

When I drag command buttons to Excel's Standard Toolbar I get grayed-out
icons as follows:

Hide Detail
Show Detail
Insert Rows

Ironically the following buttons, dragged in precisely the same fashionto the
Standard Toolbar, work satisfactorily:

Insert Columns
Delete Column
Delete Row

Any suggestions? Has MS discoveed and repaired these bugs for the May
2004 updates?

 

[JE McGimpsey]

While they're not bugs, they are confusing.

You probably dragged the Insert Rows button from the Edit category,
which is used with the List Manager, rather than the Rows button from
the Insert menu, which inserts rows in the worksheet. The List Manager
icons are context sensitive in that they are deactivated unless a List
is active. Unfortunately, they have the same icon, so it's really a pain.

The Hide and Show Detail buttons are context sensitive, and won't be
active unless you have grouped rows/columns in your sheet, or a Pivot
table active.

There's no fix necessary, obviously, and I can't comment on specifics,
but my evaluation is that MacBU has made significant efforts in
real-time documentation in XL04.