viewing cell contents in toolbar

[balanda]

Earlier versions of excel included a toolbar command which enabled
viewing of cell contents in toolbars

This appears to have disappeared in excel 2004

If anyone can advise me how to do this [ie view selected cell contents
in editable form in the toolbar, just as font and font size etc can be
viewed in the toolbar] I would be most grateful

thanks

Peter Anderson
Darwin Australia

 

[JE McGimpsey]

Earlier versions of excel included a toolbar command which enabled
viewing of cell contents in toolbars

This appears to have disappeared in excel 2004

If anyone can advise me how to do this [ie view selected cell contents
in editable form in the toolbar, just as font and font size etc can be
viewed in the toolbar] I would be most grateful

I may be confused here, but the only thing I know of that can be put in
a toolbar is a control. The Formula Bar (choose View/Formula Bar) has
the formula box control, where the contents of the active cell are
displayed.

That control ID is 8214, so you could put it in a custom toolbar by
typing something like this in the VBE Immediate Window:

Commandbars("Custom 1").Controls.Add id:=8214

But the control then disappears from the Formula Bar, and it's rather
flaky as to size and position.

Perhaps I'm missing something...

 

[Jim Gordon]

Hi Peter,

Perhaps the formula bar has been accidentally toggled off.

Use VIEW menu and make sure there's a checkmark next to FORMULA BAR. If
not, turn the formula bar on by choosing it from the View menu.

-Jim Gordon
Mac MVP