Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this crashing for you ?
Folks
Is this also crashing your Excel ?! If so anything obvious I might have missed ? ---- Sub doStuff() Dim x As OLEObject Dim aName As String For Each x In ActiveSheet.OLEObjects aName = x.Name With ThisWorkbook.VBProject.VBComponents(ActiveSheet.Co deName).CodeModule .InsertLines .CreateEventProc("Click", aName) + 1, _ "Msgbox ""Hi there"" " End With Next x End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel Crashing | Setting up and Configuration of Excel | |||
Crashing of Excel | Excel Discussion (Misc queries) | |||
Help--Excel keeps crashing | Excel Discussion (Misc queries) | |||
excel crashing | Excel Discussion (Misc queries) | |||
Toolbars and Crashing | Excel Programming |