BeforePrint macro difficulties

[SchneidRL]

I've looked over several other posts regarding BeforePrint macros, and it
appears I've written my macro properly, but it won't execute as I expect. I
already have an Autpen subroutine that performs properly, and all I want
is for Excel to execute the same procedural steps --- presetting specific
cells --- whenever I print. I must be overlooking something in the
procedure(s) or Event(s)?

Here's the two subs:

Sub Autpen()
Range("Password") = ""
Range("SwitchShow") = 0
Range("ONOFF") = 0
End Sub


Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("Password") = ""
Range("SwitchShow") = 0
Range("ONOFF") = 0
End Sub

 

[SchneidRL]

I've looked over several other posts regarding BeforePrint macros, and it

appears I've written my macro properly, but it won't execute as I expect. I
already have an Autpen subroutine that performs properly, and all I want
is for Excel to execute the same procedural steps --- presetting specific
cells --- whenever I print. I must be overlooking something in the
procedure(s) or Event(s)?

Here's the two subs:

Sub Autpen()
Range("Password") = ""
Range("SwitchShow") = 0
Range("ONOFF") = 0
End Sub


Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("Password") = ""
Range("SwitchShow") = 0
Range("ONOFF") = 0
End Sub

BTW, once I get this macro working, will it work for File Print Preview?>

 

[Dave Peterson]

Or maybe you don't have it in the right module. It goes in the ThisWorkbook
module.

Keep Auto_open in a General module, though.

And yep, print preview will fire the _beforeprint event.

 

[SchneidRL]

THAT was the ticket, Dave! Even at 56, ya learn something new every day!
I've got all sorts of modules, with various subroutines. Since the
particular spreadsheet on which I'm working originally dates back several
years, I'm guessing that I must've created a new module whenever a new macro
popped into my head(?)

Thanks a heap!