Have a look in the vba help index for
enableevents


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Self-Calling Problem" <Self-Calling
wrote in message ...
I have a similar issue. I tried the solution listed here and it worked... a
little too well. In the Private Sub Worksheet_Change(ByVal Target as
Range)
(I'm not clear on what the ByVal Target as Range does,) the macro makes
changes to the worksheet. Specifically, it inserts a row in the current
worksheet and copies some formulas from an adjacent row.
The problem with this is that the Private Sub is calling itself when it
makes the change since the Sub causes the change that activates itself.
This
sends the macro into an infinite loop whenever I make a change and I have
to
ctrl+break to regain control. The macro stops in the middle of execution
and
restarts. Any ideas on how to make the macro only execute once or only
execute when the user makes the change instead of the macro?

"Tom Ogilvy" wrote:

Right click on the sheet tab and select view code and put in code like
this

Private Sub Worksheet_Change(ByVal Target As Range)
Set rng = Target.MergeArea
Select Case rng.Address(0, 0)
Case "A10"

Case "B2:D3"

End Select
End Sub

then call the procedures within the case statements or put your code
there.

--
Regards,
Tom Ogilvy


"Moises" wrote:

I have both cases, one with a single cell like A10, and the second case
a
range of cells with a merge format so they are displayed as a big cell
(for
example range b2..d3, with a merge format).
Thanks
--
Moises


"Tom Ogilvy" wrote:

Which is it: A10 or a range of cells that have a format of merge so
they
look like a big cell?

--
Regards,
Tom Ogilvy


"Moises" wrote:

What do I have to code in order to call a macro after a select, or
clikc on a
paricular cell?, for example, I would like to run the macro after a
select
the cell A10 or a range of cells that have a format of merge so
they look
like a big cell ?
Thanks
--
Moises