Run Code on every sheet without putting it on EVERY SHEET

[Hummuna]

Same line of code I need to run on every sheet, not once but whenever the user selects to run said command.

I have a drop down menu on every sheet and I when you select the drop down menu it will display the current sheets in the Workbook, when you select one it will instantly take you to that sheet.

Here is the code I have

Please Login or Register  to view this content.

Code for every worksheet

Please Login or Register  to view this content.

IS there anyway I can not add that to every sheet but rather just have it run only when the user uses the drop down menu.

[Trebor76]

it will display the current sheets in the Workbook, when you select one it will instantly take you to that sheet

But Excel already has that functionality - just right click on the navigation bar at bottom left any workbook and select (click on) the desired tab.