Help! I Deleted my File Menu bar Control
 

Can some one tell me how to get my file Menu bar control back
I accidentaly deleted it.

This is the line of code that I ran that delted it.

Application.CommandBars("Worksheet Menu Bar").Controls(1).delete

now I have tried to get it back using this code
Application.CommandBars("Worksheet Menu Bar").Controls(1).Enable
and this..
Application.CommandBars("Worksheet Menu Bar").Controls(1).Visible = True

Neither have brought it back Please HELP !

Dan

Help! I Deleted my File Menu bar Control
 

Dan,

Try
Application.CommandBars("Worksheet Menu Bar").Reset


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dan Thompson" wrote in
message
...
Can some one tell me how to get my file Menu bar control back
I accidentaly deleted it.

This is the line of code that I ran that delted it.

Application.CommandBars("Worksheet Menu
Bar").Controls(1).delete

now I have tried to get it back using this code
Application.CommandBars("Worksheet Menu
Bar").Controls(1).Enable
and this..
Application.CommandBars("Worksheet Menu
Bar").Controls(1).Visible = True

Neither have brought it back Please HELP !

Dan

Help! I Deleted my File Menu bar Control
 

That worked Chip Thanks

Cheers..

"Chip Pearson" wrote:

Dan,

Try
Application.CommandBars("Worksheet Menu Bar").Reset


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dan Thompson" wrote in
message
...
Can some one tell me how to get my file Menu bar control back
I accidentaly deleted it.

This is the line of code that I ran that delted it.

Application.CommandBars("Worksheet Menu
Bar").Controls(1).delete

now I have tried to get it back using this code
Application.CommandBars("Worksheet Menu
Bar").Controls(1).Enable
and this..
Application.CommandBars("Worksheet Menu
Bar").Controls(1).Visible = True

Neither have brought it back Please HELP !

Dan