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).Vis ible = True

Please Help!
Thanks,
Steve

ToolsCustomizeReset

--

HTH

Bob Phillips

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

"steve" wrote in message
...
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).Vis ible = True

Please Help!
Thanks,
Steve

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

Jim


"steve" wrote:

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).Vis ible = True

Please Help!
Thanks,
Steve

Tools=Customize

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

--
Regards,
Tom Ogilvy


"steve" wrote:

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).Vis ible = True

Please Help!
Thanks,
Steve

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.

"steve" wrote:

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).Vis ible = True

Please Help!
Thanks,
Steve

"JLGWhiz" wrote in message

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)


"JLGWhiz" wrote in message
...
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.

"steve" wrote:

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).Vis ible = True

Please Help!
Thanks,
Steve

You caught me Chip! I was not paying attention.

"Chip Pearson" wrote:

"JLGWhiz" wrote in message

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)


"JLGWhiz" wrote in message
...
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.

"steve" wrote:

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).Vis ible = True

Please Help!
Thanks,
Steve

ToolsCustomizeReset

Worked!! Thanks!

"steve" wrote:

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).Vis ible = True

Please Help!
Thanks,
Steve