Thread: How do get a macro to autorun when i change a cell in the spreadsheet?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
  
Posts: 747
Default How do get a macro to autorun when i change a cell in the spre
Mudraker had a slight oversight. The last line of mudraker's code should be:
Application.EnableEvents = True

Regards,
Greg

"Infinity" wrote:


That was quick... Thanks guys. Will try it out now.:)


--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=526617


Reply With QuoteReply With Quote