Those instructions are incorrect with regard to a Password to Open the file. They pertain only to protecting sheets or or properties of the workbook but do not prevent anyone from opening the file.
When you share an Excel file with other users, you may want to protect a worksheet to help prevent it from being changed. Right click a worksheet tab. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. The password for the downloadable Excel file is 'easy'. Lock cells to protect them in Excel for Mac. Select the cells that you want to lock. On the Format menu, click Cells, or press + 1. Click the Protection tab, and then make sure that the Locked check box is selected. If any cells should be unlocked, select them. On the Review tab, click Protect Sheet or Protect Workbook.
With the file open go to File Save As, click the Options button to supply the password & re-enter it when you click OK. Leave the same name, click Save then click Replace.
If you'd rather create a password protected version & keep the original unprotected just enter a different name and/or save in a different location. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.
If you are good at VBA code, the following code may be help you quickly to unprotect multiple sheets at once. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Click Insert Module, and paste the following code in the Module Window. Sub unprotectallsheets On Error Goto booboo unpass = InputBox('password') For Each Worksheet In ActiveWorkbook.Worksheets Worksheet.Unprotect Password:=unpass Next Exit Sub booboo: MsgBox 'There is s problem - check your password, capslock, etc.' Then press F5 key to run the code, and enter the password that you have applied for the protected sheets. (the protected sheets must have the same password)See screenshot: 4. Click OK, and the protected sheets have been unprotected at once. Unprotect multiple sheets at once with Kutools for Excel Kutools for Excel’s Unprotect Worksheet is a handy tool which can help you quickly to unprotect multiple sheets with the same password at once.: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.
![Excel For Mac, Protect Sheet Excel For Mac, Protect Sheet](/uploads/1/2/5/3/125353724/933666406.gif)
After installing Kutools for Excel, please do as follows: 1. Click Enterprise Unprotect Worksheet, see screenshot: 2. In the Unprotect Worksheet dialog box, the protected sheets will be listed in the Worksheet list box, then check the sheet names that you want to unprotect, and click OK, then input the password that you have applied for the protected sheets (the protected sheets must have the same password) in the popped out dialog box, see screenshot: 3. And then click OK, a prompt box will remind you how many sheets have been unprotected.
Then click OK, all the selected sheets have been unprotected in your workbook. See screenshot: Tips: To protect all of the worksheets within your workbook at once, you just need to apply Protect Worksheet of Kutools for Excel as following screenshot shown: Demo: Protect and Unprotect multiple sheets at once with Kutools for Excel. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:.
Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks.
Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.