Can changes to a worksheet be applied to all wksheets in wkbook?
 

I have a multi-worksheet workbook and I would like to apply format changes to
all worksheets with a macro. Is this possible?

In VBA

dim sht as worksheet

for each sht in Activeworkbook

"your format macro stuff here "

next sht


"SandyM" wrote:

I have a multi-worksheet workbook and I would like to apply format changes to
all worksheets with a macro. Is this possible?