View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] thfc1882@gmail.com is offline
external usenet poster
 
Posts: 1
Default Setting .OnAction of a command button terminates my macro.....

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