Hi there.
I have a worksheet which allows me to input sports scores.
These scores are also then populated in another area of the same sheet and my plan is to protect those duplicated cells so users don’t input data in the wrong set of cells.
The sports scores I input affect my league table also on the same sheet and I have the following code to auto update the table.
So my dilemma is when i protect the sheet - the autoupdating of the league table no longer happens - the protection is killing the macro i presume.
How can i get around this? The macro needs to run constantly forever rather than have me put in unprotect sheet, and then reprotect it at the end of the macro..
The sheetname is called Everything
If this is solvable, i have 3 other sheets in this workbook with a similar problem, macro wont autoupdate data.
I have a worksheet which allows me to input sports scores.
These scores are also then populated in another area of the same sheet and my plan is to protect those duplicated cells so users don’t input data in the wrong set of cells.
The sports scores I input affect my league table also on the same sheet and I have the following code to auto update the table.
Code:
Private Sub Worksheet_Calculate()
Application.EnableEvents = False
Range("HC2:HH18").Sort Key1:=Range("HH3"), Order1:=xlDescending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Application.EnableEvents = True
End Sub
So my dilemma is when i protect the sheet - the autoupdating of the league table no longer happens - the protection is killing the macro i presume.
How can i get around this? The macro needs to run constantly forever rather than have me put in unprotect sheet, and then reprotect it at the end of the macro..
The sheetname is called Everything
If this is solvable, i have 3 other sheets in this workbook with a similar problem, macro wont autoupdate data.