Macro to open printer box not working

[CJ-22]

The macro below is designed to print several reports. It prints a report for each ID number listed in a specific column. It works fine except when the print box opens the cancel button does not work. If I decide I want to change something and hit cancel it prints anyways. Can anyone help solve how I can get the cancel button to stop printing and just cancel? Please keep in mind I am a beginner with VBA. Thanks for any help.

Please Login or Register  to view this content.

[Leith Ross]

Hello CJ-22,

Please add code tags your post. To make your posts easier to read, copy, and edit please wrap your code.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

OR you can also do this Manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.

[CJ-22]

Sorry Leith Ross, I got it fixed. Does anyone know why I am having this problem?

[shg]

Perhaps

Please Login or Register  to view this content.