Add-on to last request
 

My last request was how to get a macro to automatically open a
password protected spreadsheet with the password in the string, and I
figured that out.

I'm now stuck on this one though. Basically, I have one spreadsheet
that when it opens, it will automatically open another spreadsheet.
Then what I'd like to have happen is to have a macro run on that newly
opened spreadsheet.

Example: test.xls is opened and through OpenNew macro, another
spreadsheet called target.xls is opened. I then need a macro
Refresh_Data on target.xls to run.

I don't want to have anything written into target.xls to automatically
run Refresh_Data when the spreadsheet is opened however since other
people open and work with it. I need to have Target.xls opened and
the Refresh_Data macro run by having something written into text.xls.

Does that make sense? If there is an easier method than what I was
thinking of, please recommend.

Thanks in advance.

Paul