Excel / after print +1
Solved/Closed
Dark1500
-
Feb 2, 2010 at 12:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 07:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 07:33 AM
Related:
- Excel / after print +1
- Fnaf 1 download pc - Download - Horror
- Tentacle locker 1 - Download - Adult games
- Fnia 1 - Download - Adult games
- Igi 1 download - Download - Shooters
- Poppy playtime chapter 1 download pc - Download - Horror
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 2, 2010 at 07:33 AM
Feb 2, 2010 at 07:33 AM
I think you need some thing like this
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.EnableEvents = False
' Cancel your actual print request
Cancel = True
'HERE ADD THE CODE FOR PRINTING THRU MACRO
'HERE INCREASE THE PRINT COUNTER BY 1
Application.EnableEvents = True
End Sub
of course when you close the sheet, make sure you save the workbook to store the changed value
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.EnableEvents = False
' Cancel your actual print request
Cancel = True
'HERE ADD THE CODE FOR PRINTING THRU MACRO
'HERE INCREASE THE PRINT COUNTER BY 1
Application.EnableEvents = True
End Sub
of course when you close the sheet, make sure you save the workbook to store the changed value