Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect print area?
Is there a way to protect the print area once it is set?
I tried turning on worksheet and workbook protection, but I am still able to change the print area. I am using Excel 2003. Thanks, Rich |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect print area?
I don't think so.
Maybe you could set the printarea to what you want in the workbook_beforeprint routine. But if the user disables macros, it wouldn't work. And couldn't the user just copy to another worksheet and print from there no matter what you tried? Rich White wrote: Is there a way to protect the print area once it is set? I tried turning on worksheet and workbook protection, but I am still able to change the print area. I am using Excel 2003. Thanks, Rich -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect print area?
I wouldn't mind if the user went to some trouble to copy and print if they so
desired, I really just want the official form to print correctly. The macro idea may be an acceptable alternative, Thanks, Rich "Dave Peterson" wrote: I don't think so. Maybe you could set the printarea to what you want in the workbook_beforeprint routine. But if the user disables macros, it wouldn't work. And couldn't the user just copy to another worksheet and print from there no matter what you tried? Rich White wrote: Is there a way to protect the print area once it is set? I tried turning on worksheet and workbook protection, but I am still able to change the print area. I am using Excel 2003. Thanks, Rich -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Volatile print area | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |