Hi,

I'm new to vba/vbs and want to know if it is possible to click a button (btnABC) in Excel and go direct to a function in another Module (myfunctionABC) and avoid the default event handler onclick function (btnABC_onclick) for the Sheet to which the button is a member.

I am restricted from changing the VBA code on the Sheet (so cannot have onclick function point to where I have written my own function, myfunctionABC) - unless I can do that via a vbscript which I run to add sheets and manipulate the Sheet appearance, e.g. add drop down, change cell values etc.

1) What vbs will inject a function into an existing Sheet,

e.g.

private sub btnABC_onclick() 

 myfunctionABC()

end sub
OR

2) Make button btnABC point directly at myfunctionABC()

cheers