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.
Hello capson,
Is the macro you posted in the first or second workbook? The second workbook must have a Worksheet_Change event macro. Without the macro in the second workbook, you will not be able to respond to when a cell changes on the worksheet. Bear in mind that this event will be triggered either by keyboard input or from VBA code. It will not be triggered by a formula result changing.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks, I was thought that would be the case, thanks I will use a command button instead
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks