If you name a macro beforeClose() this run before the workbook closes.
You can then put the code in here to make the sheets protected.

Thanks
Paul

"Neo1" wrote:


Hello, I want to make sure that my workbook doesnt close until every
single sheet is protected if any worksheet is left unprotected then the
user must protect it before being able to close the workbook, How can i
do this...possibly showing an error message too...

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=531466