Normally, If I create a macro/sub and click the macros button on the developer ribbon I see a list of available macros that are formated as one word. For example, I have macros named: Refresh, GetStats, PositionFill etc.. I can easily assign a shortcut ket to these or call them in a sub routine using "Call GetStats".
However, I have one macro that keeps changing the name to included the file name. 'Open Orders.xlsm'!DailyTrans.DailyTrans I am unable to assign a shortcut key and I cannot figure out how to call it from a sub routine with this format. When the routine was first written it acted normally but something is causing it to change. I have tried copying the contents to a new module and renaming it with no success. Occasionally it will save the conventional way but soon changes back to include the file name.
Does anyone know what is causing this and how to prevent it? Also, what is the syntax to call this routine as saved from a sub routine?
thanks
However, I have one macro that keeps changing the name to included the file name. 'Open Orders.xlsm'!DailyTrans.DailyTrans I am unable to assign a shortcut key and I cannot figure out how to call it from a sub routine with this format. When the routine was first written it acted normally but something is causing it to change. I have tried copying the contents to a new module and renaming it with no success. Occasionally it will save the conventional way but soon changes back to include the file name.
Does anyone know what is causing this and how to prevent it? Also, what is the syntax to call this routine as saved from a sub routine?
thanks