Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict / Stop Printing
Is it possible to stop anyone from printing a document?
I need to issue out a revised and updated document in excel but i don't want people to be able to print it - can this be done without using macros as people have the option to enable/disable macros? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict / Stop Printing
Everything in XL is printable and there is not much you can do about it...
-- HTH... Jim Thomlinson "Phendrena" wrote: Is it possible to stop anyone from printing a document? I need to issue out a revised and updated document in excel but i don't want people to be able to print it - can this be done without using macros as people have the option to enable/disable macros? Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict / Stop Printing
thanks for the reply.
I've been doing some digging and have come across information about adding a VB Script that will stop anyone from printing, which is useful, but when using VB people can of course not allow the macro to run.... "Jim Thomlinson" wrote: Everything in XL is printable and there is not much you can do about it... -- HTH... Jim Thomlinson "Phendrena" wrote: Is it possible to stop anyone from printing a document? I need to issue out a revised and updated document in excel but i don't want people to be able to print it - can this be done without using macros as people have the option to enable/disable macros? Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict / Stop Printing
There is a BeforePrint Event that is triggered in XL. It inclues a parameter
to cancel the print job, but as you say if macros are not enabled then it will not work. You can make it very difficult even with the macros issue but there is nothing 100% fool proof. What you can do is to set up the spreadsheet to have all sheets VeryHidden (can not be accessed by the user without getting into the VBA) except for one sheet that informs the users that macros must be enabled to use this workbook. You have a macro that on open unhides all of the sheets and hides the instruction sheet. If macros are enabled then they never see the sheet that tells them they need to enable macros. If they do not enable macros then they can not (easily) get at the data sheets. With macros enabled it is easy to stop the printing... post back if you want the code to do something like this... -- HTH... Jim Thomlinson "Phendrena" wrote: thanks for the reply. I've been doing some digging and have come across information about adding a VB Script that will stop anyone from printing, which is useful, but when using VB people can of course not allow the macro to run.... "Jim Thomlinson" wrote: Everything in XL is printable and there is not much you can do about it... -- HTH... Jim Thomlinson "Phendrena" wrote: Is it possible to stop anyone from printing a document? I need to issue out a revised and updated document in excel but i don't want people to be able to print it - can this be done without using macros as people have the option to enable/disable macros? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to restrict printing to black and white | Excel Discussion (Misc queries) | |||
How to stop form printing | Excel Worksheet Functions | |||
how do you stop from printing too many pages? | Excel Discussion (Misc queries) | |||
Why does printing PDF stop at a worksheet? | Excel Discussion (Misc queries) | |||
How to restrict printing to only completed tables in spreadsheet?. | Excel Discussion (Misc queries) |