View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andyjim Andyjim is offline
external usenet poster
 
Posts: 70
Default Transferring control from macro in one workbook to macro in anothe

I am including the entire macro, but it is the last 3 lines that I am
concerned about. Basically, by the time the macro gets to that point, 2
workbooks are open. I am running the macro from the User workbook. But I
want to go to the module in the Dev workbook and use the Update3 macro in.

When I now run the macro, the error states that it can't find Update3 (which
is in the Dev file.

How do I tell Excel to go the the module in Dev file that has Update3?

Thanks much.