run a macro 30 days from a specified date on workbook open

[union]

hello everyone, i wanted to run a macro 30 days after I have saved my workbook from a specified date that i have saved on let's say cell "a1". any suggestions or tips? Thus 30 days from the specified date on "a1" as the workbook opens, it would run the macro.

btw the macro is to protect the worksheet if you were wondering.


thanks

[playaller]

Paste this in ThisWorkbook VBA window

For 30 days exactly:

Private Sub Workbook_Open()

If Date - Sheets("Sheet1").Range("A1").Value = 30 Then
'do this
Else
'do nothing
End If

End Sub

or for past 29 days:

Private Sub Workbook_Open()

If Date - Sheets("Sheet1").Range("A1").Value > 29 Then
'do this
Else
'do nothing
End If

End Sub