excel standard toolbar has disappeared

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drmewwi@gmail.com - 29 Oct 2007 16:47 GMT

I've just (last week) switched over from PC to Mac, so I'm still not
familiar enough with Mac to fix many problems that are arising.

In Excel (Office 2004), the standard toolbar has disappeared, even
when it's checked off to appear. I don't know where it should be
stored in order to search for, modify, or replace it. Any ideas?

thanks,
MjR

Reply to this Message

JE McGimpsey - 29 Oct 2007 17:31 GMT

> I've just (last week) switched over from PC to Mac, so I'm still not
> familiar enough with Mac to fix many problems that are arising.
>
> In Excel (Office 2004), the standard toolbar has disappeared, even
> when it's checked off to appear. I don't know where it should be
> stored in order to search for, modify, or replace it. Any ideas?

First, try, in the Tools/Customize/Customize Toolbars/Menus... dialog,
select the Standard item (so that it's highlighted, not just checked),
and click Reset.

If that doesn't work, and you don't have any customizations you want to
save, the easiest way is to, with XL closed, delete the

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

file (where ~ is your home directory).

Alternatively, you can type Opt-F11 to enter the Visual Basic Editor,
type CMD-g to open the Immediate Window, then enter these lines, each
followed by Return:

Commandbars("Standard").Position = msoBarFloating
Commandbars("Standard").Top = 100
Commandbars("Standard").Left = 100
Commandbars("Standard").Visible = True

Position the bar back in the dock as desired.

if you want to prevent the bar from becoming undocked in the future, see

http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html

Reply to this Message

drmewwi@gmail.com - 31 Oct 2007 14:32 GMT

thanks, deleting the toolbar file worked!

--MjR

Reply to this Message

Mac Forum / Applications / Excel / October 2007

excel standard toolbar has disappeared