SharmaAntriksh
New Member
- Joined
- Nov 8, 2017
- Messages
- 31
I am using the bellow event procedure of VBA and i want to restrict certain users from printing this file excluding me.
For eg - David, Carly and Rachel are not allowed to print the file but Jim, Antriksh, Grant and Rohit can print the file
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "You're Not allowed to print"
Cancel = True
End Sub
please let me know if there is a solution for this
For eg - David, Carly and Rachel are not allowed to print the file but Jim, Antriksh, Grant and Rohit can print the file
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "You're Not allowed to print"
Cancel = True
End Sub
please let me know if there is a solution for this