It's been a long time, so, I'm probable wrong, but...
I believe that you will need to access the desired macro thru a sub in ThisWorkbook.
Dim X As new Excel blahblah
X.SubToRunDesiredMacro
X + Dot + Name of Macro in ThisWorkbook
It's been a long time, so, I'm probable wrong, but...
I believe that you will need to access the desired macro thru a sub in ThisWorkbook.
Dim X As new Excel blahblah
X.SubToRunDesiredMacro
X + Dot + Name of Macro in ThisWorkbook
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ