Sleeper: Changing Print Range with Protection

[alwaysXcel]

Hello All,

How can I allow users to make changes to print ranges on a protected worksheet (contents only)? I was looking around in the forum but didn't find anything specific that allows the users to customize the print ranges.

I appreciate all your help!!

Thank you!!!!:beerchug:

[Jacob Hilderbrand]

Even with a protect worksheet, the user can still set the Print Area.

File | Print Area | Set Print Area

[Zack Barresse]

And transversley to clear all print ranges in the workbook .. http://www.vbaexpress.com/kb/getarticle.php?kb_id=125

HTH