Forum Discussion

INeedHelpSoon's avatar
INeedHelpSoon
Copper Contributor
Jul 26, 2022

Protect WorkSheet but change cell values via VB without password dialogue

I have a worksheet with macro control. Other than control, the whole sheet is "locked" and password protected. When clicking on the control, I want to change some values in the worksheet (via VB code...
developer
excel
Macros and VBA
JKPieterse's avatar
JKPieterse
Silver Contributor
Jul 28, 2022

INeedHelpSoon Sure, something like:

Sub ChangeSomething()
    ActiveSheet.Unprotect "PasswordGoesHere"
    Range("C3").Value = "Entry Into cell C3"
    ActiveSheet.Protect "PasswordGoesHere"
End Sub

Resources