Print Range Setup
 

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?

Print Range Setup
 

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?

Print Range Setup
 

Hi,

Not sure of what you mean but you can use Page Setup Sheet Print Area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MCheru" wrote in message
...
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?

Print Range Setup
 

would this help?

Private Sub Workbook_BeforePrint(Cancel As Boolean)

On Error Resume Next
Intersect(Range("A1:N116"), Selection).PrintOut

End Sub



On 24 Lut, 05:34, MCheru wrote:
Is there a way to setup/format a Worksheet so that it won’t print anything
outside of A1:N116 but it can print any selection within that range? *

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?

Print Range Setup
 

I meant those are the steps I take.

"Ashish Mathur" wrote:

Hi,

Not sure of what you mean but you can use Page Setup Sheet Print Area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MCheru" wrote in message
...
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?

Print Range Setup
 

O interesting. I hadn't thought of this. Thank you!

"Jarek Kujawa" wrote:

would this help?

Private Sub Workbook_BeforePrint(Cancel As Boolean)

On Error Resume Next
Intersect(Range("A1:N116"), Selection).PrintOut

End Sub



On 24 Lut, 05:34, 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?