LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Shape.OnAction stops working after workbook closed and re-opened

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User defined menu stops working when workbook saved with a newname??? alan82 Excel Programming 4 March 19th 09 05:53 PM
DIR not working after first workbook opened. Barb Reinhardt Excel Programming 2 February 9th 09 07:59 PM
How to have workbook automatically protect when closed (or opened) [email protected] Excel Programming 2 May 17th 07 01:37 PM
After sharing workbook VB code stops working. Runtime Error 1004 Patrick LaFerriere Excel Programming 0 October 5th 05 04:01 PM
Capturing Shape Name/Text from OnAction property William Bartusek Excel Discussion (Misc queries) 3 April 12th 05 06:38 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"