J
JRK
Hi
Despite the response to my last question, I still have a problem resolving
an issue I have with Print Preview. I want the user to be able to preview a
WS, but I don't want the user to Print the WS. Here's what I did:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
But that prevents Print Preview from showing, which defeats my purpose. I've
tried several IF statements without success.
Can anyone please help this excel-dummy create the correct procedure to show
Print Preview, but not allow it to Print? Thank you.
Despite the response to my last question, I still have a problem resolving
an issue I have with Print Preview. I want the user to be able to preview a
WS, but I don't want the user to Print the WS. Here's what I did:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
But that prevents Print Preview from showing, which defeats my purpose. I've
tried several IF statements without success.
Can anyone please help this excel-dummy create the correct procedure to show
Print Preview, but not allow it to Print? Thank you.