Add password protection by locking the VBA project for viewing. Save the workbook as a macro-enabled file with the `.xlsm` extension. Close and reopen the workbook, enabling content to activate ...

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.

I tried to set a password on it again, but I’m getting the following error: “This workbook contains Excel 4.0 macros or Excel 5.0 modules.

If multiple users work in the same Microsoft Excel file, you can limit their access to only the ranges where they need to work.