Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a set of icons which are made up of 3-4 individual
shape objects grouped together. One of those objects needs to respond to a mouse click which I achieve using the OnAction setting, ie. shp.GroupItems(shp.Name).OnAction = "ShapeClick" where the shape and the group have the same name. Connector lines are used to join the icons up into a network. Unfortunately in XL2007 when connecting a line to the object the click event fires so to avoid this I first set OnAction to "" and then set it back to my macro after connections are made. Initially this works beautifully however after closing and re-opening the workbook it stops working and my OnAction code line results in "Application-defined or object-defiend error". Does anyone have any idea why simply closing and re-opening the workbook might be having this effect? Thanks, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User defined menu stops working when workbook saved with a newname??? | Excel Programming | |||
DIR not working after first workbook opened. | Excel Programming | |||
How to have workbook automatically protect when closed (or opened) | Excel Programming | |||
After sharing workbook VB code stops working. Runtime Error 1004 | Excel Programming | |||
Capturing Shape Name/Text from OnAction property | Excel Discussion (Misc queries) |