how to disable print button in preview

's Computer Specifications

hOW DO i DISABLE PRINT BUTTON IN PRINTVIEW

's Computer Specifications

Add the following to your workbook code. Note that if the user has macro's
disabled it will not prevent it.

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

"lABUDDY" wrote:

> hOW DO i DISABLE PRINT BUTTON IN PRINTVIEW

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disable Preview Button in Print Dialog Box	Ryan H	Microsoft Excel Programming	0	10th Jul 2009 03:14 PM
Disable Setup button on Print Preview screen	Jon Ley	Microsoft Excel Programming	3	3rd Dec 2007 09:22 AM
Disable page break preview button	Frederik Vanderhaegen	Microsoft Excel Programming	0	21st Dec 2004 03:15 PM
Disable Page Break Preview Button	John Salig	Microsoft Excel Programming	1	10th Feb 2004 10:19 AM
How do I disable the Margins button in Print Preview Window	John	Microsoft Excel Programming	0	23rd Jul 2003 03:43 AM