Excel – VBA – How can I protect formulas from being deleted or changed?

Before protecting the worksheet:

  1. Select all cells that users ARE allowed to change;
  2. On the [gs keyboard], press Ctrl + 1 to open the Format Cells dialog box;
  3. On the Protection tab, remove the check mark from Locked;
  4. Click OK, to close the dialog box;

Protect the worksheet in Excel 2007

  1. On the Excel Ribbon, click the Review tab;
  2. Click Protect Sheet.

Protect the worksheet in Excel 2003

  1. Click the Tools menu, then click Protection;
  2. Click Protect Worksheet.

I've lost my password!

Well, there are passwords and there are passwords.

  • One is to open the file;
  • one other is to unprotect the [gs worksheet];
  • still another is to unprotect the [gs workbook];
  • yet another one is to unprotect the Excel VBA [gs macro] code.

File and VBA passwords cannot be cracked by a "normal macro", [gs workbook] and [gs worksheet] passwords are fairly easy. A search for "excel password" at http://www.google.com/ will find both commercial and free solutions of varying quality and brutality.


LINK (Contextures.com)