I would still protect the worksheet when the workbook is opened.

West wrote:

Dear Dave and Gord,

I'm quite used to the <Tool<Protection<Protect<Password or the
<tool<option<security procedures.

The problem usually arise as follows :-

I've created a few shared spreedsheet for reporting purposes with some of
the ranges protected for my own certification.

The problem is, sometimes after unprotecting, making changes or updating the
protected ranges, I tend to close the file without turning the 'protect
function' back on and thus having others acces to the protected ranges.

West,
Langkawi Island, malaysia

"Dave Peterson" wrote:

I'm not sure what you mean by auto protect workbook. But I try not to do
anything when I'm exiting the workbook.

Anything that you do would have to be saved to take effect for the next time.

If the user opens the workbook and screws it up really, really bad--deletes 32
worksheets(!) and then tries to close without saving and your code does a couple
of things and then saves the workbook, the user won't be happy.

You may want to try to piggyback on when the user saves the file or you may want
to rely on macros being enabled when the workbook opens and protect it then.



West wrote:

--
West,
Langkawi Island, malaysia

--

Dave Peterson


--

Dave Peterson