| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Varify status before runing code
Is there any way to prevent the code below from runing if the following
formula (on the active worksheet) is True WEEKDAY(C4)=7 If Union(Target, Range("A22:C25")).Address = Range("A22:C25").Address Then EmployeeList.Show |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Varify status before runing code
Hi Patrick,
At the top of the sub, try inserting: If Weekday(Range("C4")) = 7 Then Exit Sub --- Regards, Norman "Patrick Simonds" wrote in message ... Is there any way to prevent the code below from runing if the following formula (on the active worksheet) is True WEEKDAY(C4)=7 If Union(Target, Range("A22:C25")).Address = Range("A22:C25").Address Then EmployeeList.Show |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reuest formula for auto update status & status date | Excel Worksheet Functions | |||
| Help with status bar code | Excel Programming | |||
| VB code still runing | Excel Programming | |||
| VB code still runing | Excel Programming | |||
| How to display status and keep code running | Excel Programming | |||
Hybrid Mode
