View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GeorgeR GeorgeR is offline
external usenet poster
 
Posts: 13
Default Invoke Macro on entering data in column

Hi all
Getting a bit frustrated with this. Using Excel 2007.
I have a worksheet "CallList" with Column P named "Lead"
I am attempting to invoke a "Sort"macro automatically that would be
triggered by the insertion of data into Column P. Unsure of code to call
macro from VBA. I think its should be invoked from the worksheet module. This
macro will be stored in Personal workbook but I need to be able to import it
into a number of different workbooks each week.
Any help would be appreciated.

Thanks very much!!