Hi All,
I'm trying to intercept a button click on a non-standard excel button which is represented as an OleObject but when I set up the class the only events available are GotFocus and LostFocus.
Whilst I could probably use these with some coding work arounds the events don't work anyway- nothing gets triggered when I click off of my button onto a different part of my sheet.
The button's I'm using do not cast to the CommandButton type so cant use the events associated with that.
anybody know why you only have GotFocus and LostFocus for OleObjects and how I can intercept a mouse click on these objects?
I'm trying to intercept a button click on a non-standard excel button which is represented as an OleObject but when I set up the class the only events available are GotFocus and LostFocus.
Whilst I could probably use these with some coding work arounds the events don't work anyway- nothing gets triggered when I click off of my button onto a different part of my sheet.
The button's I'm using do not cast to the CommandButton type so cant use the events associated with that.
anybody know why you only have GotFocus and LostFocus for OleObjects and how I can intercept a mouse click on these objects?
