sethu29
02-28-2013, 01:26 AM
Hi support,
Through Schedule Task, daily im opening a macro and running Automatically. But i want a simple validation with if condition before running the macro automatically. If A1 cell value on sheet 2 is True then i want to run the macro. if false i dont want to run the both macro.
Please help me.
The below code im using now to run the macro automatically.
Private Sub Workbook_Open()
Run "ThisWorkbook.Send_Mail"
Run "Send_Mail"
End Sub
Through Schedule Task, daily im opening a macro and running Automatically. But i want a simple validation with if condition before running the macro automatically. If A1 cell value on sheet 2 is True then i want to run the macro. if false i dont want to run the both macro.
Please help me.
The below code im using now to run the macro automatically.
Private Sub Workbook_Open()
Run "ThisWorkbook.Send_Mail"
Run "Send_Mail"
End Sub