I have an excel macro workbook (File A) that uses the "Name Manager" tool to list the tab names in the file on a worksheet called "SUMMARY" (via a simple macro: LINK)
I have another excel file (File B) that adds File A ("SUMMARY") as a linked workbook. When I connect this worksheet from File A, all of the cells which use the macro formula show an error as if it is unable to recognize the macro. How can I get File B to recognize the macro in File A so the list of tab names in File A show up in File B?
Thanks in advance!
I have another excel file (File B) that adds File A ("SUMMARY") as a linked workbook. When I connect this worksheet from File A, all of the cells which use the macro formula show an error as if it is unable to recognize the macro. How can I get File B to recognize the macro in File A so the list of tab names in File A show up in File B?
Thanks in advance!