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 Auto_Open 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 Auto_Open()
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

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 Auto_Open 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 Auto_Open()
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?

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 wrote:

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 Auto_Open 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 Auto_Open()
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

--

Dave Peterson

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!

"Dave Peterson" wrote:

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 wrote:

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 Auto_Open 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 Auto_Open()
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

--

Dave Peterson