Yes, you can do all that all the time for all your sheets and
workbook.
Comes a time you forgot all about it.
You need an add-in
Lucky 4 you you can rely on James to handle all your files in once :
http://www.allocator.nl

Robert MS XL VSP