Disable Excel Print
 

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...

Disable Excel Print
 

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" wrote:

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...

Disable Excel Print
 

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

"Mike H" wrote:

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" wrote:

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...

Disable Excel Print
 

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

On Sun, 20 Jan 2008 13:40:00 -0800, Scott R
wrote:


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

"Mike H" wrote:

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" wrote:

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...

Disable Excel Print
 

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

"Gord Dibben" wrote:

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

On Sun, 20 Jan 2008 13:40:00 -0800, Scott R
wrote:


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

"Mike H" wrote:

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" wrote:

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...

Disable Excel Print
 

Scott R wrote...
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.

Disable Excel Print
 

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

"Harlan Grove" wrote:

Scott R wrote...
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.