how can i run a macro from a formula
Fred,
Try this =<Function Name(D10,"=1000")
Make your macro a function and place it in the formula in place of the
<Function Name.
"FRED" wrote:
i CREATED A VERY SIMPLE MACRO TO DELETE ROWS, BUT I WANT TO CALL IT WHEN
CERTAIN CONDITIONS ARE TRUE, IT IS POSSIBLE CALL A MACRO FROM A FORMULA? I
THINK THAT IN LOTUS 123 THERE IS A COMMAND TO EXECUTE A MACRO SO SHOULD BE
ONE IN EXCEL.
THANKS
|