excel standard toolbar has disappeared

[drmewwi]

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

 

[JE McGimpsey]

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

~:Libraryreferences: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

 

[drmewwi]

thanks, deleting the toolbar file worked!

--MjR