i have a macro that works when you press a big button (saves a copy on the
hard drive, emails out a copy, prints out a copy, cleans the purchase order
so it's blank, increases the counter, then saves it again.)

i want an if / then statement so that it will only work if the value in cell
M7(the date) < "[Ctrl] ;]" - i want them to use [Ctrl] ; so that they have
entered the correct date

i have tried the following at the very begining of the macro:
If .Range("M7") < "[Ctrl] ;" Then
w/ end If at the very end of the macro.

it will not work. can that statement work, or is there another sub date
macro that can be used to enter the current date when the macro is run?


regards,

jat

see reply to your later posting

--
Regards

Roger Govier


"jatman" wrote in message
...
i have a macro that works when you press a big button (saves a copy on
the
hard drive, emails out a copy, prints out a copy, cleans the purchase
order
so it's blank, increases the counter, then saves it again.)

i want an if / then statement so that it will only work if the value
in cell
M7(the date) < "[Ctrl] ;]" - i want them to use [Ctrl] ; so that they
have
entered the correct date

i have tried the following at the very begining of the macro:
If .Range("M7") < "[Ctrl] ;" Then
w/ end If at the very end of the macro.

it will not work. can that statement work, or is there another sub
date
macro that can be used to enter the current date when the macro is
run?


regards,

jat