VBA-Before_Print worked last week but now does not

[Royzer]

Hi.

My workbook has over 30 sheets. Whenever the printer icon is pressed I need the active worksheet to hide columns L and K, print the sheet, then unhide the columns. This code worked perfectly last week but now it doesn't and I can't think of anything that's changed.The code is located in ThisWorkbook. I would greatly appreciate any help you could give me. Thank you.

Please Login or Register  to view this content.

[royUK]

You must have typed this into the VB Editor, use the right hand drop down in the workbook module

Please Login or Register  to view this content.

not

Please Login or Register  to view this content.

[Royzer]

That worked! Thanks RoyUK!

[royUK]

Please mark the thread as solved


How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save