In a module I have the following code:
UserResponse = MsgBox(Prompt:="Print Worksheet", Buttons:=vbYesNoCancel, Title:="Print Worksheet")
Select Case UserResponse
In a command button I call the module code:
My objective is to have the user select a Print Option through a command button (there will be hundereds of worksheets (each with a Print command button). They can select Print Preview and Print or simply Print. When I select Print Preview I get a only the first row; When I select Print I get a blank sheet of paper. Therefore, I must have something wrong in my module.