Hello,
I am working on two macros and both are currently in same file A: Running first macro asks user input for the name of file B and creates it. It also creates a button in file B which is linked to second macro in file A. When more input is entered in File B and button is clicked, it calls second macro in file A. In the first macro when button is assigned to second macro, the name of file A is also coded.
For this happen, it is necessary to have file A same name (another unkown user might change the file name and macro will not run or give error) and file A remain open. I found that even though file A is closed, clicking the button opens the file and runs the second macro in File A.
this is the code for button:
I would like to know how can I copy the second macro into file B while its being created so clicking button in file B will run the second macro which is located in the same file. any other options?
Bookmarks