Opv
04-08-2012, 02:27 PM
I'm experiencing an odd occurrence. At times, although not all the time, when I change a cell in a worksheet in Workbook A, Excel begins to open Workbook B and I get prompted concerning whether I want to allow macros in Workbook B. If this happens, once it happens I can't do anything in Workbook A without unless and until such time as I close all workbooks, exit Excel, restart Excel and open Workbook A again.
The only script I have in Workbook A is a short and simple Private Sub in one of the Worksheet modules to auto-populate two cells in that worksheet when a certain condition is met. (This is NOT, however, the worksheet that I'm working in when the above phenomenon occurs.)
I've gone through all of my relevant scripts in Workbook B and assured that they only run if Workbook B is the active workbook. That did not resolve the problem. Last time it occurred, I disabled all script in every module in Workbook B, and I still couldn't modify Workbook A. With each attempt, a message popped up and indicated that the macros in Workbook B were disabled. I had to totally exit Excel and start over before I could edit Workbook A.
Does this behavior ring a bell with anyone?
The only script I have in Workbook A is a short and simple Private Sub in one of the Worksheet modules to auto-populate two cells in that worksheet when a certain condition is met. (This is NOT, however, the worksheet that I'm working in when the above phenomenon occurs.)
I've gone through all of my relevant scripts in Workbook B and assured that they only run if Workbook B is the active workbook. That did not resolve the problem. Last time it occurred, I disabled all script in every module in Workbook B, and I still couldn't modify Workbook A. With each attempt, a message popped up and indicated that the macros in Workbook B were disabled. I had to totally exit Excel and start over before I could edit Workbook A.
Does this behavior ring a bell with anyone?