Password-Protected Macros Open the Excel worksheet where you wish to place the macro and then activate the Visual Basic for Applications options by turning on the Developer tab.

If you have sensitive data you'd like to keep from prying eyes in a Microsoft Excel file, the easiest way to protect it is with Excel's built-in password tools.

You worked hard to put that Excel sheet together, now protect it from unintended damage.

If a user inadvertently changes the formulas in your Excel workbooks, all your hard work could go out the window. This ebook explains how to protect and hide those formulas so they remain safe and ...

14. To make all cells editable again, click on "Unprotect Sheet" — which is in the "Protect" tab under "Review" — and re-enter your password. The cells will now be unlocked.