Hi Tom,

See John Walkenbach's solution and code at:

http://www.j-walk.com/ss/excel/tips/tip48.htm

---
Regards,
Norman



"Tom" wrote in message
...
Hi guys,
I have a file that contains many workseets - I have a cell on my "main"
sheet that contains a dropdown list of the names of the worksheets. What I
would like to be able to do is be able to select the worksheet name from
the
dropdown list and click on a PRINT button that I already created beside
the
dropdown box and have that specific worksheet print out. Any ideas?
Thanks!