Print Preview Delemma, Once More Please
 

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.