With the Excel file open select File in the top-left corner of the screen, followed by Info. Select Protect Workbook, then choose Encrypt with Password.

When a worksheet is hidden using `xlSheetVeryHidden`, it cannot be made visible again through the Excel user interface, adding an additional layer of protection to your sensitive data.

Open the spreadsheet you want to protect in Excel, click the "Review" tab and then click "Protect Sheet" in the Changes group to display the Protect Sheet dialog. The "Protect worksheet and ...

Open the Excel file you want to protect with a password. Click on File -> Info. Now select Protect Workbook. Select Encrypt with Password from the list. Now enter the password. Confirm it once ...

Once the final version of your Excel workbook or Microsoft 365’s version of Excel Workbook is complete you might want to stop or turn off the workbook sharing in Excel to avert any unwanted changes.

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

Once all the workbooks are closed, the Application.Quit statement closes Excel. If you want to leave Excel open, you can comment out this statement. If Excel is open, close it.