If you never want to allow normal printing from that workbook then just use:
I don't see the need for the global variable PrntOK.![]()
Public Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True MsgBox "You can't print this workbook" End Sub
If you never want to allow normal printing from that workbook then just use:
I don't see the need for the global variable PrntOK.![]()
Public Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True MsgBox "You can't print this workbook" End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks