I believe macro text is locked during combat to prevent 'intelligent' addons. I don't think modification on the fly is possible with the current API.

I'd just like to know if my estimated click rate is my actual click rate. I try to self-monitor but it's difficult to stay calm and spam consistently during intense fights and sometimes normal fights.