Strange problem with reference to another workbook

T

Todd Huttenstine

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
 

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

Need Help with Macro Security 1
Password protect new workbooks from template 0
Enabling Macros message when NO macros in workbook 3
Search function 0
Cell values to an array, then array transpose to another workbook 8
Referencing another workbook using a variable for the sheet? 20
Cross referencing two workbooks? 3
How can I open an Excel Workbook from Outlook macro and activate that workbook? 1

Top