Disable Excel Print

[Scott R]

Hi guys,

Just womndering if there is a way to disable printing in an excel worksheet
or wook. I know you can in pdf but trying to do it in excel... any suggestion
would be appreciated...

 

[Mike H]

Hi,

Alt+F11 to open VB editor. Double click 'This Workbook' and paste this in

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

Mike

 

[Scott R]

Hi Mike,

I actually need to prevent people from printing the workbook. Your
suggestion seems to only work if they enable macros. Are there any other
methods to prevent printing that cannot be overridden?

Thanks

Scott

 

[Gord Dibben]

You can add more code that makes the workbook unusable and unfit for printing if
they disable macros.

Involoved, but doable.

I don't know of any way to prevent printing a workbook/worksheet or range of
cells without code.

Except to have no printers installed


Gord Dibben MS Excel MVP

 

[Scott R]

Thanks for that Gord.. ill look into it and decide whether its worthwhile
doing.

 

[Harlan Grove]

I actually need to prevent people from printing the workbook. Your
suggestion seems to only work if they enable macros. Are there any
other methods to prevent printing that cannot be overridden?

No.

There's no robust way to prevent printing from Excel. As for your
earlier PDF example, if PDF files can be displayed, they can be
printed via Print Screen. Or you could use something like Snag It to
OCR portions of your screen. Slow and arduous, but possible.

Basic rule of IP protection: if a file can be opened, it's content is
unprotected and could be copied.

 

[Scott R]

Thanks Harlan, I think Ill just have to trust them not to print
Appreciate your reply.