Can you restric when a macro is able to run

[bloodmilksky]

so if there is a date that is defined in range a1 that is within 48hrs then the macro wont run? and offers a MsgBox instead?

many thanks

jamie

 

[NoSparks]

Can you be more specific ?
When would you want the macro to run ?
When the workbook is opened, when the sheet is activated, when the date in entered into a1, ????

 

[footoo]

If [A1] >= Date - 2 Or [A1] >= Date + 2 Then
    MsgBox "Exit"
    Exit Sub
End If

 

[bloodmilksky]

so if the date in the range declared is within 48hrs of todays date.

 

[footoo]

Did you need something different?