View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan Thompson Dan Thompson is offline
external usenet poster
 
Posts: 125
Default 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