What I'd really like is some VBA code to unlock the cells after applying formatting rather than defining which cells might be editable in advance. As this macro does not ask you to confirm your password. This will unprotect all worksheets that are protected and protect all worksheets that are unprotected. Press Alt/Option-F8, select ShowPass, and then click Options and assign a shortcut key. I have tried allowing edits before I lock the sheet and after. Close the window to get back to Excel, then save your workbook. So now I need to allow the following cells to be editable by the user Sheets('Sheets2'). 'Test', Range('C2', 'C8')

> Me.Worksheets('Sheet3').Protect 'Password', UserInterfaceOnly:=True Verifying that a set password on a worksheet is correct though VBA. Your vba loop sheets in looping is a spreadsheet with just need to copy and use for recording is event or not be. Using VBA to unprotect a sheet that has been protected with UserInterface Only true. > Me.Worksheets('Sheet2').Protect 'Password', UserInterfaceOnly:=True Ive been trying to make the below code work on all sheets in my workbook instead of just the active sheet but instead it gets stuck in a loop after the third worksheet. > Me.Worksheets('Sheet1').Protect 'Password', UserInterfaceOnly:=True Otherwise, you can open it from the Developer Tab. Press Alt+F11 :This will Open the VBA Editor.

Please follow the below step by step instructions to execute the above mentioned VBA macros or codes: Open an Excel Worksheet. > 'protects all sheets upon opening work book VBA Unprotect Worksheet Method- Instructions.

I have code that will look the cells for the user interface only but allow VBA to edit them. So I have a spreadsheet that I want to format based on user inputs, but the cells need to remain locked until it is determined by the formatting that they will be user input cells.

Excel macro unprotect all sheets