IF Sstatement in macro

[Corleone]

I have a spreadsheet with 2 macros attached to it

1 - to run at the start of the week

the other - to run at the end of the week.

I would like to put some code on each of them which prevents the user
from running them in the wrong sequence.

eg - If CELL A10 contains "in progress" then I would like the 1st macro
to be disabled.

if CELL A10 contains "Closed" then then 2nd macro needs to be disabled

any ideas appreciated

thanks

 

[HalfAce]

It would be helpful to see the code in these routines, but maybe this is enough to get you going.
(Replace Sheet1 with whatever the sheet's name is...)

In your first routine, begin it with:
If Sheets("Sheet1").[A10].Value = "in progress" Then Exit Sub
Or with:
If Sheets("Sheet1").[A10].Value <> "Closed" Then
the rest of your code ...

In the second routine, begin it with:
If Sheets("Sheet1").[A10].Value = "Closed" Then Exit Sub
Or with:
If Sheets("Sheet1").[A10].Value <> "in progress" Then
the rest of your code...


Then at some point, you'll want to make sure that A10 has the value either "in progress" or "Closed" in it. Most likely that would probably come from the end of these routines...

at the end of rourine 1:
Sheets("Sheet1").[A10].Value = "in progress"

at the end of the second...
Sheets("Sheet1").[A10].Value = "Closed"

but without seeing the code these are only guesses.

Another idea would be to have the current date in the workbook somewhere, and test for the days of the week that you want either of these routines to run on... or not...

Hope it helps,
Dan

 

[Corleone]

Perfect

thanks!! ray:

 

[HalfAce]

Most welcome.
Glad it helped.