Re: Using a macro to create a macro in another workbook
I had one of those "aha!!" moments and figured it out myself. What I did was make the macro in workbook A a worksheet macro. I then copied the worksheet over to workbook B.
As is the way with these things, the solution created another problem. The macro was connected to a button, and the link on the button went back to the version of the macro on worksheet A. Even reassigning without the path did not help. The reassignment required the path of the macro version in workbook B. Here's the code that I used: