Before And Befoe Close Macros For Excel... Why Doesnt This Work?
Private Sub Workbook_BeforePrint()
MsgBox "PDF File before Print! Printer Name: Adobe PDF", vbExclamation
End Sub
Sub Workbook_BeforeClose()
MsgBox "Sensitive INTERNAL Information MUST be hidden!", vbExclamation
End Sub
MsgBox "PDF File before Print! Printer Name: Adobe PDF", vbExclamation
End Sub
Sub Workbook_BeforeClose()
MsgBox "Sensitive INTERNAL Information MUST be hidden!", vbExclamation
End Sub
You forgot to add parentheses
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox ("Write whatever you want here to appear as prompt")
End Sub
Sub Workbook_BeforeClose()
MsgBox ("Sensitive INTERNAL Information MUST be hidden!")
End Sub
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox ("Write whatever you want here to appear as prompt")
End Sub
Sub Workbook_BeforeClose()
MsgBox ("Sensitive INTERNAL Information MUST be hidden!")
End Sub
You forgot to add parentheses
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox ("Write whatever you want here to appear as prompt")
End Sub
Sub Workbook_BeforeClose()
MsgBox ("Sensitive INTERNAL Information MUST be hidden!")
End Sub
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox ("Write whatever you want here to appear as prompt")
End Sub
Sub Workbook_BeforeClose()
MsgBox ("Sensitive INTERNAL Information MUST be hidden!")
End Sub