Disable user access to master sheet through doubleclicking locked linked cell

Thanks for the reply, however I don't think I have done a good enough job of explaining my problem. Let me try again. I will streamline the details, but include all relevant factors hopefully.

I have a master workbook that I input data into. This workbook feeds info via links to several other workbooks that several users use (1 wb per user). I use this method to prevent me from having to make changes to several workbooks. Instead I change/update the cells and this info is pulled over the next time each user opens their workbook.

The cells in the user workbooks that are linked to the master are locked and password protected. There is no need for them to be edited, nor is there a reason they would be highlighting them at all. Because of this I have also unchecked the option that you mentioned below when protecting them: select locked cells.

Even though I have put all these protections in place I have had users inadvertantly try to edit the data in the locked protected cells that are linked back to my master, and excel assumes that you would like to access that master workbook (where the links come from) so it starts to pull up the document.

Here's an example: Workbook A is the Master with all the data, Workbook B is the users workbook populated only with data from links to the master.
Workbook A has info in A1. Workbook B's A1 cell is linked to Workbook A, but is locked, is non-selectable and is protected. Yet, when I doubleclick on A1 in Workbook B, excel tells me that the cell is protected, I click OK and then starts pulling up Wb A and asks if I would like to open it in read only mode.

I don't know if it's a glitch or what because I would assume that if you go to the trouble to lock and protect a linked cell, you propably don't want users to have access to the original workbook where the linked data is coming from.

Any further help would be appreciated.

Originally Posted by 6StringJazzer

I understood your explanation perfectly, but I learned something new about Excel. I set up a prototype and was dumbfounded to find that Excel allows the user to double-click on a locked cell on a protected sheet where locked cell selection is prohibited. That does trigger it to open up the linked workbook.

At any rate, the code above does solve this problem. However, it has to be in your users' workbooks and they have to allow macros to run.

Yes, it does seem odd. I will give your code a try here in a bit. Thanks for your feedback and for sticking with my problem. Have a good one!

Originally Posted by 6StringJazzer

Please Login or Register  to view this content.

I looked at your code again and now it makes complete sense. I misread it the first time through and assumed that you were having it do something else. Sorry, I'm pretty new to this stuff. This should work perfect! thanks again 6String!