Peter Stahl
03-27-2014, 2:05 PM
I copied a sheet from Excel Workbook(1) to another Workbook(2) and now when the Formula is run in Workbook(2) the original Workbook(1) opens. I don't see any reference in the formula referencing the other Workbook. Any ideas how I can change the Link or what ever it is to the other Workbook? Also if you know of a free Excel Forum please let me know.
thanks, Pete
I figured out what was going on, It was the Macro Name in the buttons I had assigned. They don't change and when I clicked on the button it would open the other workbook to get to that Macro.
thanks, Pete
I figured out what was going on, It was the Macro Name in the buttons I had assigned. They don't change and when I clicked on the button it would open the other workbook to get to that Macro.