Creating a Macro to print worksheets

[vonbates]

Hello. I have a 30+ worksheet excel document. I would like to have a lead worksheet with a drop down box. The items in the drop down box should tie to each worksheet. Ideally I could select one of the worksheets (States in this case) from the drop down and it will automatically print the corresponding worksheet.

Any ideas or tips? Is this even possible.

Thanks for your help!

[brokenbiscuits]

You could attach a macro to a button next to the drop down (this assumes your dropdown menu is in A1, obviously amend as required):

Please Login or Register  to view this content.

[john55]

or
see the attached file, it might help you.

john

http://www.excel-it.com/excel_tutorials.htm