URGENT - File Menu!

[Guest]

I'm learning how to make cutom tool bars. I used an example I got from
J-Walk, but I accidentally named my custom menu "File". It deleted Excel's
"File" menu, now I can't get it back.

I've tried:
Application.CommandBars.FindControl(ID:=30002).Visible = True

Please Help!
Thanks,
Steve

 

[Bob Phillips]

Tools>Customize>Reset

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

I would try re-installing MSOffice. That may be the only recourse.

 

[Guest]

Tools=>Customize

In the toolbars tab, select worksheet menu bar and click the reset button.

 

[Guest]

When you commit a major blunder and you catch it before you have saved the
file, simply close the file without saving and everything will be as it was
before the blunder. If you want to save your work up to that point, then
copy it to a new workbook and when you reopen the original file, you can copy
it back. In this case, you had an out that could restore your menu to its
original state.

 

[Chip Pearson]

When you commit a major blunder and you catch it before you have saved the
file, simply close the file without saving and everything will be as it
was
before the blunder.

Not in this case. The menus and commandbars are completely separate from any
particular workbook (unless they're Attached), and closing a workbook
without saving won't restore the menus.

The first thing I'd try is
Application.CommandBars.ActiveMenuBar.Reset

If this didn't work, I'd delete the XLB file (Search for "*.xlb" . The name
and location will vary depending on your version of Excel and of Windows.



This should be
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

 

[Guest]

You caught me Chip! I was not paying attention.

Not in this case. The menus and commandbars are completely separate from any
particular workbook (unless they're Attached), and closing a workbook
without saving won't restore the menus.

The first thing I'd try is
Application.CommandBars.ActiveMenuBar.Reset

If this didn't work, I'd delete the XLB file (Search for "*.xlb" . The name
and location will vary depending on your version of Excel and of Windows.



This should be
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

 

[Guest]

Tools>Customize>Reset

Worked!! Thanks!