prtFile = InputBox("Enter a file name (with/without extension?)", "FILE
NAME")
Workbooks(prtFile).PrintOut





"caldog" wrote in message
...
I have multiple worksheets to select from, but the user will only need to
print one of those sheets. How can I in code through an input box
function
ask the user to input the sheet name that is needed to be printed?

I have just checked for the last hour hunting for an answer, so sorry if
this question has been asked before.