macro will not run with file.xls!macro.macro

[BillRobPV]

I have two macros on a file daynite.xls. When I have just the macro name
(dynt or GetData) listed in the tools/macros/macros messagebox, they run fine
using ctrl+a (or+b), but when they are listed as daynite.xls!getdata.getdata,
or
daynite.xls!dynt.dynt, they will not run. I don't know how to insure that
only the macro name is listed, not the full path. I do not have any other
files running (unless they are hidden). TIA

 

[Dave Peterson]

Try changing the module names that contain the macros.

It can confuse excel when you have the same module name as macro name.

I'd use ModGetData and ModDynt.

 

[BillRobPV]

Thank you Dave. Works perfectly. "We get too soon old and too late smart."