I am unable to create a macro for a particular document. I wrote it in another spreadsheet and would just copy and paste the code into the new spreadsheet. But in the new spreadsheet, I click "create" under macro, nothing happens. When I go to the VB editor, and click create, it says "Out of memory". It only does this for this one particular spreadsheet. I didn't make the spreadsheet, I was just trying to create a macro for it. Is there some setting or preference that the author may have used that I can change? Any reason why it does that?
I can run it if I have both open and pull from the other spreadsheet, but that is kind of burdensome to tell them they have to have this blank spreadsheet open just to use the macro...