We have a very large ss, thirty nine sheets and about twenty pages of macros. Saved the file as .xlsb to speed things up, but when we run a macro, it opens up the original .xlsm file and runs it there, not on the new file. We then saved the file as a .xlsm but under a different filename, and again, it opened the original file when any macro is run. Nowhere in any of the macros is the actual filename referenced, so where in the workbook is it pointing to the original file? Thanks,
How do you run the macros? That is, how do you initiate them? Are they associated with buttons? Do you call them from the Developer > Macros > Run interface?
Ideally you should provide the file but it may be over the size limit. You can attach a .xlsb file up to 9.7MB.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
We have made a custom ribbon with the macros assigned there. The xlsm version is just over 100M, the xlsb is about 40M
Macros in the ribbon or the QAT are bound to a specific file, not whatever file is currently open. I am assuming that the file does not build and load the ribbon customizations dynamically when it starts, but rather you have set this up in advance. If you right click anywhere on the ribbon, select Customize the Ribbon, and then hover the mouse over the custom command, you will see what file it refers to.
Hover to see macro location in ribbon QAT custom command.jpg
Learn something new every day .. So it was pretty easy to simply make a new custom ribbon and everything works fine, thanks for that
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks