Run Macro when opening another sheet
Posted by Brian S. on December 11, 2001 8:22 AM
I got such great help from Tom Urtis & Bill Robbins that I'm back!
I have a sheet that comes from another data source. I have a macro that I would like to have run automatically when the person opens the sheet. How do I do this? I currently have the macro saved as another excel file.
Ie..i get a file named capacity from another data source, when I open this sheet I would like to run capacitymacro which is contained in sheet2.