| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Resorting Deleted Menu/Toolbar | Excel Discussion (Misc queries) | |||
| Control item PRINT in menu FILE of Excel | Excel Discussion (Misc queries) | |||
| Suddenly deleted Tools Menu | New Users to Excel | |||
| How can a control be deleted? | Excel Discussion (Misc queries) | |||
| Menu Item Deleted | Excel Programming | |||
Linear Mode
