Hello,
I have all my Macros in a .xlsm workbook and they act on a 2nd open .xlsx worxbook
I need to run a macro on cell change within a range (cells in column A) in the .xlsx file on sheet(2)
Is it possible to do this from the 1st .xlsm workbook?
I found many variations of the macro below but they all need the code to be placed in the Sheet of the column with the cells that change, which is a .xlsx file not a .xlsm file
Thanks for any help on this
Please Login or Register to view this content.
Bookmarks