How Do You Password Protect Worksheets In Excel 2007?
There are many reasons for needing password protection for a worksheet within a workbook. If you have a worksheet that contains sensitive and important data feeding a pivot table, you may want to password protect the worksheet with the data. Maybe the worksheet has a macro importing data from another source you need to protect in order to prevent the data from being changed accidentally. Whatever the reason, these simple steps will walk you through the process to password protect and secure the worksheet. At the bottom of the Excel file, select the worksheet (tab) you wish to protect. Click the “Review” tab on the toolbar at the top of your screen. Click “Protect Sheet” in the “Changes” section of the “Review” tab. A small screen will pop up with the cursor in a blank box. Type the password you wish to use to protect the worksheet. Click “OK” at the bottom. Another screen will pop up asking you to retype the password to verify you typed it correctly the first time. Before you click “OK
