print a worksheet out from another worksheet

[rutima - ExcelForums.com]

Hi all,
I have a validation list that shows all the worksheets in the
workbook, I want to beable to select the a worksheet from the list
and print it out without having to go to the sheet. Can this be done
if so how?

Cheers

 

[Ron de Bruin]

Hi

With the list in A1 on Sheet1 for example you can use this macro

Sub printtest()
Dim str As String
str = Sheets("Sheet1").Range("A1")
Sheets(str).PrintOut
End Sub

 

[rutima - ExcelForums.com]

Thank you for that I will give it a try

Cheer