Workaround for the formatting of multiple sheets part of the problem:

If you can remember to do this at the start of one of the pages that you are
getting ready to set up and format in a way that you'd like all, or many, of
your sheets to have that can't be done in grouped sheet mode, you could
record a macro while setting up the first (or more likely the 2nd <g) one
and then just run it on each subsequent sheet. Then delete the macro when
you're done?

As for the lock/unlock multiple sheets - I don't know of any workaround
other than code/macro.

"Mhz" wrote:


This Is something I was looking forward to in 2007, Unfortunately
Conditional Formating Is Still Bound To One Sheet... as well as not
being able to lock/unlock multiple sheets unless you're running a
macro... Still Have to Copy and Paste in Most Instances to
get things done on multiple sheets..


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=560974