Heart's desire is to be able to

in turn activate each worksheet in a workbook,
select an entire worksheet,
use Format Painter to capture the formatting,
save that formatting some way (clipboard to xml?),
temporarily modify the formatting of the worksheets,
and then later re-apply the correct original Format Painter
formatting to each worksheet

Anyone know enough about the Format Painter to know how to tackle this or if
this is even possible?

Excel gurus - please don't fail me now!!!

James Cox