Runtime error 1004, cannot run macro RRS feed

  • Question

  • Hi there I am having some trouble working out the reason for an error.

    I have the following code, which is activated by the click of a button in a userform. It is supposed to run a macro saved in the "ThisWorkbook" part of the VBAProject.

    For some reeson which is a mystery to me, when I go through the process step by step (with F8), no error appears - it does everything as I want it, but when i try to run the whole thing in one go (F5) it produces a "run-time error 1004" and says "Cannot run the macro '"!Import_from _Prodn'. The macro may not be available in this workbook or all macros may be disabled."

    Can anyone shed any light?


    Monday, August 18, 2014 4:08 PM


All replies