I created a spreadsheet in Office 365 Excel for Mac that contains macros. They ran fine. I then created several different files from that, saving them under new names, in order to incorporate examples of analysis of different data sets. I then found that I couldn't run the macros in the "saved as" files unless the original file that they were saved from was located in the same folder/directory. This was true even though when I view the macros "in the current workbook" they are listed.
Is there some way to "break the link" between new files and the original file and let the macros in the new files run without referring to the original file in the same folder/directory? Thanks!
--Eric55
Bookmarks