Reset sheet tab menu commands

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top