How to Allow Value Changes to Excel Protected Cells Using Macros

1. Select 'Edit' > 'Find' > 'Options' > 'Format' > 'Select Locked' > 'OK' > 'Find All.' This will identify which cells are actually locked. On an unmodified sheet, you can skip this step since all cells are marked as Locked by default.
2. Select 'Tools' > 'Visual Basic Editor' and type 'Sub unlockit.' Press 'Enter.' On the next line, type 'End Sub' (minus quotes). In between these two lines is where you will enter the macro.
3. Type in 'Range('A1..A20').Locked = False.' The range can be any range of data you want to unlock. This line can also be entered in an already existing macro where needed.
4.
Always save your work to avoid redoing it.
Select 'File' > 'Save.' You can either run the macro manually from 'Tools' > 'Macro' > 'Macros,' or use the Forms toolbar to create a button on your worksheet and assign the macro to it.