Lock Macro Print Settings

[shawnsdad]

Hello!

This might be pretty simple but I have reached the end of my googling abilities and didn't see another thread related to this problem. I created print macro for my team but each time someone changes a setting inside the workbook, it screws all of the print settings up for the macro. I understand that before BeforePrint option will help lock this in place but I continue to get a Expected End Sub error that I cant seem to get rid of. Thank you for your help. The code is below from VBA.

Please Login or Register  to view this content.

If that's not right please let me know.

[Winon]

Hello shawnsdad,

If you follow the Forum Rules, only then will I be allowed to offer some assistance.

Administrative Note:


We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Regards

[shawnsdad]

I made an update. Not sure if it right.

[Winon]

Hello shawnsdad,

If you follow the instructions in the Post, the Code you want to Post should look like this:

Please Login or Register  to view this content.

So go back to your Post and, Click on Edit Post, then Highlight the code and click on the # Icon. Then Submit your post again.

[shawnsdad]

I think I got it now. Thank you.

[Winon]

Hello shawnsdad,

Thank you!

Please try the Code below in place of what you have. (Replace the Code in Total for that procedure)

Please Login or Register  to view this content.

Paste the Code in the ThisWorkbook-event Code, without the first line of your original Code - "Sub ThisWorkbook()"

HTH

[shawnsdad]

Thanks. That's where I was able to get to before but it won't link to an existing macro or allow me to create and link it to one. Any thoughts?