Does Excel 365's Personal.xlsb have to be located in 'AppData\Roaming\Microsoft\Excel\Startup' folder in order for macros in it to be available to other workbooks? I have it located in a user folder called 'Startup' and I have specified that Excel open any workbooks in that folder when starting, so Excel opens it upon starting. However, the only way that I can use macros in this Personal.xlsb is by using 'Application.Run "Personal.xlsb!macroname.
The reason I ask is that I cannot seem to create a reference to that Personal.xlsb in VBA; i.e., it does not appear in available references, nor can I reference the Personal.xlsb in the user folder.
This is not a problem in Excel 2003 where I can reference the Personal.xls in the user folder, and use macros in it in other workbooks without doing 'Application.Run'.
Thanks.
Update: I moved the Personal.xlsb file to the %AppData%Microsoft\Excel\Startup folder and I can now reference it under VB Tools\References Available References. That made the macros in it available to other workbooks. Is there a way that I can keep the Personal.xlsb file in a user folder and create a reference to it there?
Thanks.
Bookmarks