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