Home |
Search |
Today's Posts |
#1
|
|||
|
|||
protect from printing
how can I protect an excel sheet from being printed. I want others to view
but not to print. Thank you for your help |
#2
|
|||
|
|||
If your users can view the sheet, they'll be able to print. You can
disable the Workbook_BeforePrint command: Put this in the ThisWorkbook code module of your workbook: Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub However, starting up with macros disabled will defeat this. So will copying and pasting the sheet. And macro security is easily bypassed in any case. If you and your users are on a 2003 Server network, I believe you can use IRM to prevent others from printing. I don't think it prevents the user from taking a screenshot and printing that. In article , "scott" wrote: how can I protect an excel sheet from being printed. I want others to view but not to print. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell borders printing black instead of grey | Excel Discussion (Misc queries) | |||
problem printing to PDF | Excel Discussion (Misc queries) | |||
Can I protect a spreadsheet from being deleted or moved? | Excel Discussion (Misc queries) | |||
protect a cell | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |