Worksheet_calculate problem

  • Thread starter Thread starter routeram
  • Start date Start date
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
 
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
 
You are probably doing something wrong, but without seeing your code, it's not
possible to say.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to link several charts in the same worksheet? 2
Stop Command Question 4
Running a macro on cell value change 2
Update Cell in WKBook 1 From WkBook 2 2
Worksheet_Calculate fires for every worksheet in book? 3
Help Needed with password protection 2
Save as problem 1
Inter-Connected Worksheet_Calculate events 1

Back
Top