+ Reply to Thread
Results 1 to 1 of 1

Thread: When open File A, runs macro in File B

  1. #1
    Forum Contributor
    Join Date
    08-02-2007
    Location
    Panama & Austria
    MS-Off Ver
    XP 2003
    Posts
    182

    Exclamation When open File A, runs macro in File B

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0