hi,
I have a large model (45 sheets) , with the following code on one of the sheets
![]()
Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Sheets(1).Range("projects") If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then Call Locked End If End Sub
It works fine at the moment with only that workbook open. However, with other workbooks open at the same open its stops working and it does not start working even after I close the other workbooks.
Does anyone have any ideas?
Bookmarks