VBA Set DisplayPageBreaks to False for all worksheets

[BillXL]

Hello

I have some code the switches off DisplayPageBreaks for the active sheet.

It is as follows:
ActiveSheet.DisplayPageBreaks = False

This just works for the active sheet. Is there a way of doing the same for all worksheets in the workbook?

Many thanks

Bill

 

[Andrew Poulsom]

You could loop around the Worksheets collection.

 

[wigi]

dim wks as worksheet
For each wks in thisworkbook.worksheets
   wks.DisplayPageBreaks = False
next

 

[BillXL]

Thanks for the replies.

wigi, the code is exactly what I was trying to do - it works perfectly - thank you so much.

Bill