disable print option, not Workbook_BeforePrint
 

Hi!


I would like to allow user to use the PrinPreview

to disable this option i suppose I can use this
Sorry If I am wrong I do not have a printer!

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

but How can i prevent to print from Excel, allowing the print preview


Many thanks

--
Message posted from http://www.ExcelForum.com