Mimic another worksheet

I have a workbook with sheets for each day of the week: Mon, Tue, etc.. I have to hide and unhide rows each week. Rather than have to hide and unhide the rows on 7 different sheets, can I make all them have the same visible and hidden rows based on the Mon sheet?

Thanks.

ep

Hi,

You could use a macro or you could right click on the sheet tab Monday then select all sheets. Hide and unhide as required. All sheets will then have the same hidden rows.

This assumes you had no hidden cells to start with

VBA Noob