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