I've read many posts about this but I still don't get it!
I open a single spreadsheet xyz.xlsm. Then I run a macro that is stored in PERSONAL.XLSB (because I use it in many worksheets). So why do get the message that it is locked and asking me to choose to open it in Read Only mode? All that I read seems to imply that should only happen if I'm running a new instance of Excel, which I'm not doing here.
And I'm 99% sure I've run it without this problem before....
Bookmarks