Set print area on multiple sheets at the same time

[fizzwolf]

I have a workbook with 200 tabs all of the same format where I need to set the print area to print "Page 1" only. Is there a way of changing them all simultaneously avoiding having to set the print area in each work sheet individually?

[kev_]

with VBA
try:

Please Login or Register  to view this content.

[fizzwolf]

with VBA
try:

Please Login or Register  to view this content.

I only need to set the chosen 200 tabs and do not need them printing immediately but need to set each page' PRINT AREA via Print Set Up to only print page one when print command is used

[kev_]

How about 2 subs like this:
(difference is the range only)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Could either have 2 buttons or a single button toggle

[kev_]

Or using PageBreak property:
( which is a bit messier )

Please Login or Register  to view this content.

Or if messages 1 & 2 not helpful:

Please Login or Register  to view this content.