All,
I have a macro to lock my workbooks for field distribution - ShowPass. Each worksheet has the "select locked cells" unchecked. The cells which require data entry I will individually go to cell properties and uncheck "locked". Once the macro runs, it locks every sheet except the cells pre-selected to be unlocked.
The field guys will enter data into the unlocked cells. This macro was created to standardize all inspection forms....
I would like to have a macro which locks every cell, every sheet in a workbook, regardless of the worksheet "Protect Sheet" properties. My thought is when I send a sample workbook out for review. Absolutely, no data entry will be able to occur.Sub ShowPass() If Sheets(2).ProtectContents = False Then UserForm1.Label1.Visible = True UserForm1.TextBox2.Visible = True UserForm1.Caption = "Protect Worksheet" End If UserForm1.Show End Sub
Bookmarks