I have a workbook that is going to be shared by about 10
people...all of which will be editing various sections of
it. I need to share this workbook, but I also need some
way to protect it to prevent unauthorized changes.

I'm been playing around with this a bit, and have found
that any type of protection doesn't seem to work if a
workbook is protected. I can set it to "Read Only" but
this is a pain because it doesn't take effect until the
next time the book is opened.

What is the easiest and cleanest way to get around this
issue. This pretty simple worksheet is becoming VERY
frustrating! Any help would be greatly appreciated