Search found 1 match

by sebsimpson
Fri Apr 21, 2023 5:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE VBA Refresh in Manual Calc Mode
Replies: 1
Views: 1255

Re: PAfE VBA Refresh in Manual Calc Mode

I investigated doing something like this in PAfE a few years back and the best I could come up with at the time was to just get Excel to call the keyboard shortcut to recalculate using the SendKeys application method , in this case Shift+F9, but you can adjust the keys depending on your use case. Be...