vzachin
11-12-2008, 07:20 PM
hi,
i unprotect the workbook/sheet when the code is running and when the code is finished, i protect the workbook/sheet.
i find that if i interrupt the code using the esc key, the sheet/workbook is no longer protected.
is there a way to prevent this, so that when the code is interuppted, the workbook & sheet is protected?
then if the code is resumed(continued), unprotect the workbook/sheet until it finishes?
thanks
zach
i unprotect the workbook/sheet when the code is running and when the code is finished, i protect the workbook/sheet.
i find that if i interrupt the code using the esc key, the sheet/workbook is no longer protected.
is there a way to prevent this, so that when the code is interuppted, the workbook & sheet is protected?
then if the code is resumed(continued), unprotect the workbook/sheet until it finishes?
thanks
zach