Nov 03, 2018 · Creating a Macro in Microsoft Excel helps you automate tasks in a spreadsheet. Once these codes are present in the worksheet they can be changed intentionally or accidently by anyone who uses the sheet unless you password protect them. Learn how to password protect a VBA Project. Nov 03, 2018 · Creating a Macro in Microsoft Excel helps you automate tasks in a spreadsheet. Once these codes are present in the worksheet they can be changed intentionally or accidently by anyone who uses the sheet unless you password protect them. Learn how to password protect a VBA Project.

This procedure works in Excel 2010 and earlier but in Excel 2013 this will not work. In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps. Mar 18, 2017 · Suppose you are going to share an Excel workbook to your colleagues. However there is a worksheet with sensitive data that you don’t want them to see. So you hide the worksheet. As you know Excel well, you further Protect Workbook, with password set, in order to avoid user from unhiding ...