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

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

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