Excel Guides

Using Macros in Protected Workbooks in Excel

Macros can be a great way to automate repetitive tasks in Microsoft Excel. However, if you have sensitive data in your workbook, you may not want anyone to be able to access or change your macros. In this case, you can protect your workbook with a password.

To password-protect a workbook in Excel, first open the file. Then, click the File tab on the ribbon and select Info. Next to Protect Workbook, click the Edit button.

In the Protect Workbook dialog box, select Password. Enter a password in the Password field and click OK. Re-enter the password in the Confirm Password field and click OK. Your workbook is now password-protected.

Note: If you forget your password, there is no way to recover it. Make sure to choose a password that you will remember!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.