Date to stop macro

[vmjan02]

Hi I have an bill data macro in excel 2007, I just want a code, if any person click on the Run button, the macro should not run

eg:- if in the system date is 10 Feb 2013 and any person clicks on the run button the macro should not run.

Thanks.

 

[ChrisR]

Hi,

What is the criteria? What relevance is 10 Feb 2013?

Where is this date stored? Does this mean that you have reports whereby the date is blank or a future date? So, in effect, you are comparing a date in a cell against the current date?

Is this correct? You will need to provide further details in order to get a resolution.

Thanks

 

[ChrisR]

P.s. If you did just want to compare a cell to todays date you could use something simple like this

If Range("A1").Value<Date Then
Exit Sub
Else
*** Enter Macro code here***
End if
End Sub

 

[vmjan02]

we need to pick the date form the system. as my macro do not have any date column or so

I have fig it as

this

on the workbook open

If Now() >= "20/01/2014 00:00:00" Then
Worksheets("Ubsoft").OLEObjects("CommandButton1").Enabled = False
End If
Worksheets("Ubsoft").OLEObjects("CommandButton1").Enabled = True
End Sub