I've made some macros and saved them to the ribbon. But now I can't find them and I no longer have the file the were created with. Is there a way that I can see the code for the macros? I found my .xlb file at C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\" (Office 365), but I can't open them from there.
the XLB file is automatically opened when you start Excel. Go to the Visual Basic Editor (ALT+F11), you should see your XLB file there with all the macros saved in it.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks