I have two files (File A and File B). If I have file A open, when I open File B, it automatically runs the "Private Sub Worksheet_Calculate()" procedure in file A. What could be the reason for this?
Specifications:
File A:
-12 tabs (all with formulas and links to other tabs within the file).
-The "Private Sub Worksheet_Calculate" procedure just looks for empty cells in a column and hides the row for those cells.
-This is a new file which i'm currently working on.
File B:
-Is a completely different file to file A
-It has several macros including "On workbook open" and "Private Sub Worksheet_Calculate"
-Old file, never had problems with it.
Questions:
-The worksheet where the "Private Sub Worksheet_Calculate" is located has a cell (B3) wich compares the value of Cell (B3) in all other 11 cells. Could this be causing the problem?
-When a worksheet has a "Private Sub Worksheet_Calculate" procedure and there is some calculation in that worksheet do it runs all the "Private Sub Worksheet_Calculate" procedures in the rest of the worksheets (including all "Private Sub Worksheet_Calculate" procedures in other open files?)
-Any idea why when running a macro in File B, it runs the calculate macro in File A?
I appreciate all help you could provide me.
Thanks.
Last edited by Wizz; 08-28-2007 at 06:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks