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

  • Thread starter Thread starter BillRobPV
  • Start date Start date
B

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
 
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.
 
Back
Top