Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print preview error from BeforePrint macro | Excel Discussion (Misc queries) | |||
BeforePrint help | Excel Programming | |||
BeforePrint macro | Excel Discussion (Misc queries) | |||
Macro syntax difficulties (long post) | Excel Programming | |||
BeforePrint Add In | Excel Programming |