I have my macro all set to format a report. The last thing I had to do was
pass in the date of the report since the ETL happens elsewhere. So, when I
took:

Sub LoadData()

and changed it to

Sub LoadData(dt As String)

the macro name disappeared from my run macro list and the script that calls
it can't see it either. Is there some way to pass a parameter into a macro
like this?