In VBA you can choose which macro to run using any of the conditional
statements, so

If condition then
Call macro1
else
Call macro2
endif

of more simply for just one macro

If condition then call macro1

Cheers
Nigel

"nightshift12 " wrote in
message ...
is it possible to have a macro run automatically using an "if" statement
?


---
Message posted from http://www.ExcelForum.com/