Thread: macro not found
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default macro not found

It could be a private sub.

It may not be in a standard code module.

It may be in an other workbook.

By your last statement,did you include the addin name in the run statement?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brian Murphy" wrote in message
...
What different reasons are there for getting the following error message:

Run-time error '1004':

The macro 'filename!macroname' cannot be found.


I'm certain the file is present and open, and that the file contains the
macro that is being run.

A syntax error leading to a compile error does not seem to be the culprit.

This is a case where one addin is trying to run a macro in another addin

by
way of an Application.Run statement.

Thanks,

Brian Murphy