If you mean an IF statement in a worksheet, then no. Worksheets can only
call functions that return a result, they cannot run a macro that modifies
the Excel environment.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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


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