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 26, 2022
You can't have VBA code unprotect a sheet without the PW dialog and at the same time without including the password. But you can protect the VBA project so others cannot see the password. Would that help?
  • INeedHelpSoon's avatar
    INeedHelpSoon
    Copper Contributor
    Jul 28, 2022

    JKPieterse  

    Yes that would help... suggestion?

    • 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