VBA code needed to stop people selecting locked cells.

Hi guys,

I've created a dashboard where only unlocked cells can be selected, using the Review - Protect Sheet menu option and unticking the Select Locked Cells option at the top of the list. This works perfectly on mine, but when I open it up on someone elses PC they are able to select the locked cells. It's still protected, so they can't delete anything, but I want them to only select the cells that I allow. Does anyone have any code that will run automatically when aomeone else oprns the dashboard and remove the tick in the box for all sheets?

Cheers,

Jed.

ActiveSheet.EnableSelection = xlUnlockedCells

Perfect