Worksheet_calculate problem

R

routeram

Hi,

I have 2 workbooks, both using macros. Both work fine when ru
separately. The trouble is when I have both these open. I hav
worksheet_calculate events in both these workbooks. The problem is whe
I execute a macro in workbook1, the worksheet_calculate procedure o
workbook 2 is executed and it gives me an error. Any ideas what i
going on and how to avoid it. Is this expected?

I could think of explicitly naming the workbook each time I refer t
some sheet on it.

Eg. Charts("Chart1") could be changed to
workbooks("Workbook1").Charts("Chart1")

Thanks.

Ra
 
R

routeram

Hi,

Thanks. Is this really expected? Why is excel triggering some othe
workbook's event when it shouldn't be. Or am I doing something wrong?

Ragards,
Ra
 
M

Myrna Larson

You are probably doing something wrong, but without seeing your code, it's not
possible to say.
 
Top