Disable Print for the set of worksheets.

[muralidaran]

Hi
Is there any chance to cancel print for set of worksheets? For example in workbook with Sheet1 to Sheet4, i wish to allow printing only for sheet4 and all other sheets to disable print.

Thanks.

[HaHoBe]

Hi, muralidaran,

if you want to disable the individual print of worksheets you may try this code in ThisWorkbook:

Please Login or Register  to view this content.

Ciao,
Holger

[muralidaran]

Hi Mr. HaHoBe
Thanks for the code but i was looking code to prevent printing some set of sheets (Multiple sheets).
Thanks.

[HaHoBe]

Hi, muralidaran,

maybe have a look at this code:

Please Login or Register  to view this content.

Ciao,
Holger

[muralidaran]

Hi Mr. Hahobe
Thanks but from the beginning of my request is to prevent some set of sheets from printing.
something like below but no luck....

Please Login or Register  to view this content.

[HaHoBe]

Hi, muralidaran,

maybe something like this (although Sheet4 from the opening post is missing in your last code):

Please Login or Register  to view this content.

Ciao,
Holger

[muralidaran]

Hi Mr. Hahobe
Thanks a lot that worked fine....