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

S

SandyM

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

Vacation's Over

In VBA

dim sht as worksheet

for each sht in Activeworkbook

"your format macro stuff here "

next sht
 
Top