I'd like to be able to remove the colorizing of all cells, print the
worksheet, and then restore the colorizing. It's easy to cycle among
the cells, setting the cell shading to "none," but how would one go
about saving / restoring the shading/colorizing.

Shading/colorizing doesn't print well on a B/W printer. The cell text
is often unreadable.

Thanks for any help.

Fred Holmes

Of course I could remove the shading/colorizing, print, close without
saving, and re-open the workbook, but that entails certain "hazards"
of lost data.