VBA Code for Selecting sheets

[Speed boy]

Please help...
Have a workbook w/ 32 sheets. Would like a drop down box on page 1 that lets you choose which sheet you want vs. scrolling through all those tabs. And ideas?

 

[stargazer]

George, Thanks very much. I will give this a try shortly. Regards, Bob

 

[Speed boy]

This code is quick and very efficient. This was an awesome tip and great for end-user applications using mutliple sheets.

SB

On 2002-04-06 04:36, stargazer wrote:
George, Thanks very much. I will give this a try shortly. Regards, Bob