Putting a macro within a sheet that isn't yet open...

[bilbo85]

Hey there,

I have one macro that creates and opens a new workbook.

I also have another macro that when you click on a cell within a certain column, it finds and opens a specific file (using the file name that is listed in that particular cell).

Is it possible to somehow use this second macro within the new workbook (that has been opened from running the first macro)? It should only be available to use within the new sheet and not any others that may be open. I also don't want to name the new sheet that opens.

Thanks in advance.

 

[Fluff]

Duplicated https://www.mrexcel.com/forum/excel...o-within-sheet-isnt-yet-open.html#post5001152

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.