"Sub or Function not Defined" error -- cannot determine cause

Hello,

This is my first post so please forgive me if I am doing anything wrong. Thanks in advance for your help.

I have multiple macros in two different workbooks, and a "Master" macro which is intended to switch back and forth between activating the two books, calling subs in each. It won't even get past the first few lines:

Please Login or Register  to view this content.

The Master is stored in "Blank Template with Macros.xlsm" which is the active book when Master is run. When I try to run it, I get a "Sub or Function not Defined" error and the line containing Call Create_Defects_Raw_Data_Pivot is highlighted. The workbook "Weekly Feedback Raw Data.xlsm" contains the create pivot macro. Here is the code for the create pivot macro:

Please Login or Register  to view this content.

This sub works fine when I run it from the feedback workbook. Shouldn't I be able to call the Create_Defects_Raw_Data_Pivot sub once the "Weekly Feedback Raw Data.xlsm" book is activated? Am I wrong in assuming that a public sub should be accessible if it is in the active workbook?

Please let me know if you need more info.

Thanks for your quick reply -- I actually tried this already. I get the run-time error 1004:

Cannot run the macro 'Weekly Feedback Raw Data.xlsm!Create_Defects_Raw_Data_Pivot'. The macro may not be available in this workbook or all macros may be disabled.

I changed the trust center settings to enable all macros in Weekly Feedback Raw Data, but running the test macro gave me the same 1004 error.

Worked that time -- thank you so much!!

So would you recommend calling subs this way any time I run a macro that calls subs in different workbooks? Do you have any idea why activating the workbook was not sufficient?

Very good to know and thank you again.