|
Hi all,
Just wondered if anyone was aware of the correct technique to activate certain formulas on an active form via a switch.
For example, in my Active Form I have a series of hidden columns with DBS statements in them. Now I only want these to fire when an Action Button is clicked. Normally I would have just reverted to VBA, and wrapped these DBS's in an IF statement referring to a Cell named "SendSwitch", get the VBA to update the Cell with a 1 and recalc the sheet and then change it back to 0 and recalc again so the links are in effect dead.
As I need this to function in TM1Web VBA is not an option, is there a way to replicate this kind of functionality with Action Buttons?
Also as a separate item, I am only able to view the properties behind any action button after it has been executed (The TM1 Properties dialogue box, not the VBA one, which is available in design mode), before that time the properties option is greyed out (After Right Clicking on the button), is this default behaviour?
Thanks in Advance |
|