Dropdown Menu to Select Worksheet

[Dick Stumbo]

I have an excel template that has 20 worksheets. I want to
have a drop down menu that will show on any worksheet and
allow me to select any other workshhet. Can anybody help?

 

[Andy Wiggins]

Right click on the worksheet scroll arrows (they're the ones just to the
left of the worksheet tabs) and Excel presents you with what you want.

http://www.bygsoftware.com/namingofparts/namingofparts.htm

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Andy Wiggins]

Why would you want a button when the solution is alreeady there?

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Dick Stumbo]

I know it sounds strange but the 'users" I'm designing this
for need things really simple and really obvious.

Dick