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

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

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

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