Setting .OnAction of a command button terminates my macro.....
Hi Ian,
I see nothing contentious in the code snippet.
Post the following code which does not run.
---
Regards,
Norman
wrote in message
oups.com...
I am adding buttons to a spreadsheet programmatically and stepping
through the macro, it gets to the line
ActiveSheet.Buttons("Survey").OnAction = "SCI"
and the macro ends. The OnAction has been set but the macro will not
carry on after that. No error message, nothing.
I need to set the onactions of many buttons but cannot get past the
first one.
Anyone got any ideas?
Using Excel 2002.
Many thanks,
Ian
|