Hello,
I'm using an add-in that adds functions to pull data from a 3rd party program. The add-in also adds a section to the ribbon with buttons that recalculate (either the current sheet or all sheets in the book). Is there any way to activate these recalculate options in a VBA macro? They seem to work a lot faster than just the standard <sheets>.Calculate.
I tried contacting support for the people who made the add-in (who are also the people who make the 3rd party program) and they just told me that macros are up to the user. I googled the issue a bit and the only things I found involved referencing or doing things with an .xll file, which I could not find. The file that is used to install the add-in is an .exe.
Does anyone know how I might accomplish this, or where I should look to find out how?
Thanks</sheets>
I'm using an add-in that adds functions to pull data from a 3rd party program. The add-in also adds a section to the ribbon with buttons that recalculate (either the current sheet or all sheets in the book). Is there any way to activate these recalculate options in a VBA macro? They seem to work a lot faster than just the standard <sheets>.Calculate.
I tried contacting support for the people who made the add-in (who are also the people who make the 3rd party program) and they just told me that macros are up to the user. I googled the issue a bit and the only things I found involved referencing or doing things with an .xll file, which I could not find. The file that is used to install the add-in is an .exe.
Does anyone know how I might accomplish this, or where I should look to find out how?
Thanks</sheets>