Edit: Split from [Solved] Function with thisComponent.Sheets throws an error because that topic is solved so you need your own. Your situation may be different. Please do not post in another's topic unless you are helping to solve their problem for them. |
Thank goodness I found this old thread. I am in the same situation (9 years later). I moved my macros into "My Macros" because because I have spreadsheets all over the place in my file structure. Trying to keep up with making sure all the directories are Trusted to avoid "Enable Macros?" was impractical.
The interesting thing is after going through the sequence of errors messages when the spreadsheet loads, if I do a Ctrl-Shift-F9 to recalculate, everything works fine.
To me, this is clearly a bug. This dates back to 2013. Any updated information on the situation and and hopefully a workaround? (Another solution would be to be able to specify all files under a top-level directory are trusted, but I have not found a way to do that either, what I consider another glaring deficiency.)