Delete formulas when unprotect

[CaptRon]

Sheet Protection, with a password, should be sufficient for the curious, but inexperienced.
It seems to me, that deleting a sheet (i.e. ruining the spreadsheet) is more likely to harm the authorized user for clumbsyness than to add security.

I confess, I have never known of a user inadvertently removing the sheet protection, given a password was applied. Circumventing the password protection must be done purposely and with some determination. For ordinary users content to use the workbook as designed, password sheet protection is more than adequate and this code presents no hazard.

The approach detailed above is not intended for the ordinary user. Since employing these tactics more than 5 years ago, I no longer have to endure emails and phone calls from users distressed by malfunctioning workbooks "improved" and distributed by some genius too lazy or inept to create his own work but quite sure he knows how to better mine. When just once the workbook disappears before their eyes, word quickly gets around....DON'T REMOVE THE SHEET PROTECTION or the workbook is toast. I do allow them to print each page before destruction (I'm not heartless).

Another part of my need to preserve the workbook intact is that our employees do not have permission or privilege to alter agency forms/reports or workbooks that produce them, though a few are bold enough to try anyway.

All my workbooks open with a notice to the user that sheet protection must remain intact or the workbook will either self-destruct or otherwise become dysfunctional. Rather than destroy the worksheets, forcing the workbook to close without saving has proven equally effective, if properly done. Not as dramatic, but still effective.

Ron