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.