Hi,
I have a macro procedure that runs when doubleClick. This procedure is writen on the Sheet code under the "Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)".
I realize that when there is a dropBox, the procedure does not start. It drops the dropBox menu instead of running the Macro.
Is there any way to make the procedure run even when doubleclicking on DropBoxes?
Thanks very much
Last edited by Wizz; 05-13-2009 at 09:30 AM.
Depends on the type of dropbox.
If it's a Form control, then no. This only react to click.
If it's a ActiveX control then you can code in the DoubleClick event of the control
Sorry, I forgot to specify.
It is a dropBox in a Cell, created with the menubar>Data>Validation.
Would that count as a FormControl or ActiveX?
Thanks for your time.
No data validation is data validation
I can not replicate your problem. This works for me.
Please Login or Register to view this content.
You are so very right !
Now I found out, in my case, the worksheet is protected and UNchecked "Modify Object" (Not sure the right translation. In any case, it is the second option from bottom up). I have some pictures and diagrams I can not allow users to modiffy.
Is there any workarround or way I can make the "BeforeDoubleClick" work, but still keep the pictures and diagram blocked from nasty users abuse??
Thanks again.
Looks like shapes/pics/data validation all fall into the Modify Objects expection when protecting sheet.
Too bad...for me.
Thanks for your time.
Should I mark this Thread as SOLVED or just delete it?
Solved rather than delete it.
You never know somebody may find this post useful whist using the Search.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks