Print individual page by user input

I have this workbook with two tabs; sheet1"Employees", sheet2"schedule". On sheet2 there are 13 individual schedules with 28 day period. I'm trying to add a way the user can activate a button on sheet1 that ask for the user to input the month and only schedules with that month would print. Is anything like this possible? Or any other ideas to print an individual schedule. I've attached a stripped down workbook for your review.

I posted here also with no response. This may not be able to be done. http://www.vbaexpress.com/forum/showthread.php?t=44390

I found the following module code that has a input box for entering two digits for a particular week to print. Is there a way to convert this to entering month ie: January, February, etc.

Please Login or Register  to view this content.

I also found this code to search by text that will locate where text was found, but need to combine codes to search for text, ie month and be able to print that sheet.

Please Login or Register  to view this content.

Is it possible to write VBA code that if a word is found by using a userform search to be able print a preselected range? Example: User inputs "May" and the word is found on A 161 to have code then select AI 200 and print this selected area.
"January" if found it would select the following range A1:AI40
"February" if found it would select the following range A41:AI80
"March" if found it would select the following range A81:AI120
Etc.

Hi Ron

Name the ranges, for example, the Named Range for Jan=Schedule!R1C1:R40C35.

Then add this line of code

Please Login or Register  to view this content.

Worked for me on your sample file.

You're welcome...glad I could help.