| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reset sheet tab menu commands
During a recent adventure into VBA I somehow ended up with duplicate entries,
(ones I made through VBA) on the sheet tab pop up menu - the menu which appears when you right click the tab. How do I reset (clear) these duplicates. I have tried not attaching the VBA code to the current worksheet and also opened older worksheets put the entries on the menu remain. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reset sheet tab menu commands
Hit ALT + F11 to go to the VBEditor.
Then ViewImmediate Window. Copy/paste this line into the window and hit <enter Application.CommandBars("Ply").Reset Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 09:57:02 -0700, Sparky13 wrote: During a recent adventure into VBA I somehow ended up with duplicate entries, (ones I made through VBA) on the sheet tab pop up menu - the menu which appears when you right click the tab. How do I reset (clear) these duplicates. I have tried not attaching the VBA code to the current worksheet and also opened older worksheets put the entries on the menu remain. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reset sheet tab menu commands
It worked!! Thanks loads. I am keeping that tid bit handy for future screw ups.
"Gord Dibben" wrote: Hit ALT + F11 to go to the VBEditor. Then ViewImmediate Window. Copy/paste this line into the window and hit <enter Application.CommandBars("Ply").Reset Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 09:57:02 -0700, Sparky13 wrote: During a recent adventure into VBA I somehow ended up with duplicate entries, (ones I made through VBA) on the sheet tab pop up menu - the menu which appears when you right click the tab. How do I reset (clear) these duplicates. I have tried not attaching the VBA code to the current worksheet and also opened older worksheets put the entries on the menu remain. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reset sheet tab menu commands
Thanks for the feedback.
Gord On Tue, 23 Oct 2007 08:12:02 -0700, Sparky13 wrote: It worked!! Thanks loads. I am keeping that tid bit handy for future screw ups. "Gord Dibben" wrote: Hit ALT + F11 to go to the VBEditor. Then ViewImmediate Window. Copy/paste this line into the window and hit <enter Application.CommandBars("Ply").Reset Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 09:57:02 -0700, Sparky13 wrote: During a recent adventure into VBA I somehow ended up with duplicate entries, (ones I made through VBA) on the sheet tab pop up menu - the menu which appears when you right click the tab. How do I reset (clear) these duplicates. I have tried not attaching the VBA code to the current worksheet and also opened older worksheets put the entries on the menu remain. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I hide certain commands in a drop-down menu? | Excel Discussion (Misc queries) | |||
| How to deploy custome toolbar/Menu commands in Excel? | Excel Worksheet Functions | |||
| Lost my menu bar commands | Excel Discussion (Misc queries) | |||
| Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions | |||
| menu commands are gray | Excel Discussion (Misc queries) | |||
Linear Mode
