Print Range Setup
Very creative. Thank you.
"Shane Devenshire" wrote:
Hi,
There is nothing built into Excel to do this.
However, you can accomplish the same thing by doing this, suppose the only
range that you want the user to be able to print from is A1:G19:
1. Select colums H:IV and hide them
2. Select rows 20:65536 and hide them
3. Select the range A1:G19 and choose Format, Cells, Protection, and
uncheck Locked
4. Choose Tools, Protection, Protect Sheet and assign a password.
Now the user can select any part of the range A1:G19 and print it but can't
print anything else.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"MCheru" wrote:
Is there a way to setup/format a Worksheet so that it wont print anything
outside of A1:N116 but it can print any selection within that range?
|