Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Menu

Status
Not open for further replies.

Lasius

Programmer
Jul 1, 2002
13
DE
Hi,
I have a stupid question. I was testing the delete command
in excel and have run the following code:

Dim oBar As CommandBar
Set oBar = Application.CommandBars("Worksheet Menu Bar")
oBar.Controls(6).Delete

It really works fine, but how do I get back my menu. Can
somebody help?

Thanks
 

Tools/Customize/Toolbars ?

Regards
BrianB
** Let us know if you get something that works !
================================
 

Right click a toolbar, Customize/Toolbars .. Worksheet Menu Bar?

Regards
BrianB
** Let us know if you get something that works !
================================
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top