When you upload the workflow it will try to verify that the workflow can run. What will be happening is your macro is saved locally and (C:/My Documents/Me/macro.yxmc) and the server can't find the macro in that location.
To fix this you need to either install the macro in a location the server can find (shared drive or in the c drive for the alteryx server) or package the macro into the workflow as an asset (a snapshot copy of the macro)
