Printing worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Norman,
Thanks for the reply. Unfortunately, I don't think that would be the best
solution for me since I have MANY worksheets and the dialogue box created
would be quite long. I was hoping that there was a way to have the worksheet
selected for printing from the name selected in the dropdown list that is
already there.

Regards
 
Hi guys,
After trying the code that Norman suggested, I can live with the way it
works; however, can anyone tell me how to MODIFY that code so it only creates
a box containing the worksheet name that is in a SPECIFIC cell instead of a
list of all the worksheets?

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
Excel Count If Formula Question 1
Open Specific Worksheet Using Button Form Control in Excel 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Userform to Select what worksheets to print 1
Vlookup Help Please 1
Dropdown list of hyperlinks 3
single user form with multiple worksheets 1

Back
Top