Reset sheet tab menu commands

[Guest]

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.

 

[Gord Dibben]

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Ply").Reset


Gord Dibben MS Excel MVP

 

[Guest]

It worked!! Thanks loads. I am keeping that tid bit handy for future screw ups.

 

[Gord Dibben]

Thanks for the feedback.


Gord

It worked!! Thanks loads. I am keeping that tid bit handy for future screw ups.