Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With BeforeDoubleClick
On Excel I use on several sheet "BeforeDoubleClick"
When I open the first time the worksheet everything, work fine. " I double click on the a cell in the first sheet wich send me to another sheet in function of what is in this cell. in this new sheet I double click in a cell & divers calculations & manipulation of contenu of cell happens and finally send me back to the first sheet & fill the cell with the new info" Until that everything work fine but after that If i try to double click on another cell my cursor is on editing mode & what ever sheet I go if I doubleClick the cursor is on editing mode. I have to close the worksheet & Excel also to be enable to have the Double Click working but only on the same way as before. Any Help will be very appreciated. Jean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With BeforeDoubleClick
As a guess at some point you disable events witout re-enabling when you are
done. Application.EnableEvents = false 'your code 'Application.EnableEvents = True 'missing this Look for places where you might be exiting the sub or ending such that you do not run the code to re-enable. -- HTH... Jim Thomlinson "jean" wrote: On Excel I use on several sheet "BeforeDoubleClick" When I open the first time the worksheet everything, work fine. " I double click on the a cell in the first sheet wich send me to another sheet in function of what is in this cell. in this new sheet I double click in a cell & divers calculations & manipulation of contenu of cell happens and finally send me back to the first sheet & fill the cell with the new info" Until that everything work fine but after that If i try to double click on another cell my cursor is on editing mode & what ever sheet I go if I doubleClick the cursor is on editing mode. I have to close the worksheet & Excel also to be enable to have the Double Click working but only on the same way as before. Any Help will be very appreciated. Jean |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With BeforeDoubleClick
Thank you very much now It work find
"Jim Thomlinson" wrote: As a guess at some point you disable events witout re-enabling when you are done. Application.EnableEvents = false 'your code 'Application.EnableEvents = True 'missing this Look for places where you might be exiting the sub or ending such that you do not run the code to re-enable. -- HTH... Jim Thomlinson "jean" wrote: On Excel I use on several sheet "BeforeDoubleClick" When I open the first time the worksheet everything, work fine. " I double click on the a cell in the first sheet wich send me to another sheet in function of what is in this cell. in this new sheet I double click in a cell & divers calculations & manipulation of contenu of cell happens and finally send me back to the first sheet & fill the cell with the new info" Until that everything work fine but after that If i try to double click on another cell my cursor is on editing mode & what ever sheet I go if I doubleClick the cursor is on editing mode. I have to close the worksheet & Excel also to be enable to have the Double Click working but only on the same way as before. Any Help will be very appreciated. Jean |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With BeforeDoubleClick
Cancel = True should work as well.
Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 09:48:01 -0700, jean wrote: Thank you very much now It work find "Jim Thomlinson" wrote: As a guess at some point you disable events witout re-enabling when you are done. Application.EnableEvents = false 'your code 'Application.EnableEvents = True 'missing this Look for places where you might be exiting the sub or ending such that you do not run the code to re-enable. -- HTH... Jim Thomlinson "jean" wrote: On Excel I use on several sheet "BeforeDoubleClick" When I open the first time the worksheet everything, work fine. " I double click on the a cell in the first sheet wich send me to another sheet in function of what is in this cell. in this new sheet I double click in a cell & divers calculations & manipulation of contenu of cell happens and finally send me back to the first sheet & fill the cell with the new info" Until that everything work fine but after that If i try to double click on another cell my cursor is on editing mode & what ever sheet I go if I doubleClick the cursor is on editing mode. I have to close the worksheet & Excel also to be enable to have the Double Click working but only on the same way as before. Any Help will be very appreciated. Jean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforeDoubleClick | Excel Programming | |||
beforedoubleclick and selectionchange | Excel Programming | |||
BeforeDoubleClick doesn't seem to work | Excel Programming | |||
BeforeDoubleClick processing question(s) | Excel Programming | |||
beforeDoubleClick (target, true) | Excel Programming |