I can call a sub in a worksheet module if I know the sheet's Code Name and use it in the call: Sheet1.DoHello
I can determine the worksheet I want and get its Code Name in another macro. But I haven't been able to figure out how to use that to call to the module and run a sub. Any help, please?
I can determine the worksheet I want and get its Code Name in another macro. But I haven't been able to figure out how to use that to call to the module and run a sub. Any help, please?