Run VBA code once

[jammerdk]

Hi guys

Know you can help me on this.

I'm trying to run a VBA code when the worksheet is loaded but only want to run it once no matter what.

I'm having this code working but as the worksheet is locked/protected I want to a variable instaid of the cell value in A1.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim N As Long
If Worksheets("Diagram").Range("A1").Text = "Done" Then Exit Sub
'code runs here
Worksheets("Diagram").Range("A1") = "Done"
End if

 

[MrKowz]

The problem is that variable values are cleared out once your macro(s) finish running. If you want to restrict a macro to run only a single time, you need to have a cell somewhere in your workbook that it can adjust, like what you have now.

What you could do is set up a worksheet and hide that worksheet, using the macro to refer to a cell in that hidden worksheet so it doesn't clutter your data.