Hopefully someone can help me with this issue, as I am now completely lost ...
I'll try and explain it in simple terms..
I have 3 workbooks:
These each have one macro:
Workbook A - Macro 1
Workbook B - Macro 2
Workbook C - Macro 3
I can run Macro 1 from A, obviously, I can run it from B, but not from C.
I can run Macro 2 from B, again obviously, and I can run it from A, but not C.
I can run Macro 3 from C, but I can't run any of the others from C.
For some reason, whenever I try to run Macro 3 from either A or B, I get the error message:
Run-time error '1004': Cannot run macro <workbook><macro>. The macro may not be available in this workbook or all macros may be disabled.
The same error message appears if I try to run macro 1 or 2 from C.
My code is exactly the same in all workbooks so I know it's not the code. I have enabled all macros so I know that the disabled part isn't true.
Has anyone else ever came across this? Is there a tick box I have missed somewhere that does not let macros be run from another workbook?
I am totally lost with this as I see no difference in workbook C that I do with any of the other two.
Any help or input would be greatly appreciated.
This is the only site I have posted on, but I have asked our IT team if they have ever came accross this and no-one had. I also checked the microsoft website for any help and found nothing on there that was related.
Thanks in advance