| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OnAction - Adding a command bar | Excel Programming | |||
| setting a command button to be a hyperlink | Excel Programming | |||
| macro terminates with no error | Excel Programming | |||
| Propblem setting OnAction property at runtime | Excel Programming | |||
| OnAction command failure | Excel Programming | |||
Threaded Mode
