View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SchneidRL SchneidRL is offline
external usenet poster
 
Posts: 3
Default BeforePrint macro difficulties

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