Personal.xlsb will not open when I start Excel, neither from the shortcut on the taskbar nor from the Startup menu. I've attempted to record a macro and save to the Personal workbook, but I get the following message: "Personal Macro Workbook in the startup folder must stay open for recording" and then I get the next message that reads "Unable to record macro." the Personal.xlsb is in the correct location of:
C:\Users\Rachel\AppData\Roaming\Microsoft\Excel\XLSTART
any thoughts?
thank you,
Rachel
If you look in the Addins section of Excel Options, is it listed in the 'Disabled application addins' section at the bottom of the list? Also, do you only have one personal.xlsb?
Good luck.
Personally I would create an addin. The personal workbook should be created when you record a macro & choose to store it there
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you, yes, it was disabled in the add-ins. That fixed it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks