dan9933
06-19-2013, 09:12 PM
So I am working on a vba data entry userform. I am working with macros and sometimes when I click on the button for the macro excel says "Cannot run the macro...The macro may not be available in this workbook or all macros may be disabled."
Sometimes all i need to do is click the button again and the macro will run perfectly so Macros are obviously enabled. Any idea why this would be the case? What causes a macro to be unavailable and what can I do to stop that?
Thanks,
Dan
Sometimes all i need to do is click the button again and the macro will run perfectly so Macros are obviously enabled. Any idea why this would be the case? What causes a macro to be unavailable and what can I do to stop that?
Thanks,
Dan