Strange problem with reference
It was checked. That did not work.
-----Original Message-----
In tools=Options, Edit tab, is "edit directly in cell"
unchecked? If so,
check it. That should change this behavior.
--
Regards,
Tom Ogilvy
Todd Huttenstine
wrote in message
...
I have multiple cells on sheet1 in workbook A
referencing
cells in sheet 1 of workbook B. I also have sheet1 in
workbook A protected. When I double click any cell on
sheet1 in workbook A, I get the expected message saying
the workbook is protected, however after I click OK, it
trys to bring up Workbook B. See workbook B has macros
so
the dialog asking to enable or disable macros pops up.
If
I click Enable Macros Workbook B opens. If I click X
workbook B does not load. I dont want Workbook B
loading
period. Why is it doing this and how do I prevent
workbook B from being opened?
Thanx in advance
Todd Huttenstine
.
|