Unable to use Macros when worksheet is locked

[Shinianne]

Good day,


I'd like to ask for your kind assistance please, I couldnt use the macros on this sheet when i lock the worksheet is there a work around on it?, even if I sent the macros unlocked. can anyone help me please thank you so much. below are the Macros i use in a sheet.

Sub Resolved()
'
' Resolved Macro
'


'
ActiveSheet.Range("$A$9:$E$134").AutoFilter Field:=5, Criteria1:="Resolved"
End Sub


Sub Onhold()
'
' Onhold Macro
'


'
ActiveSheet.Range("$A$9:$E$134").AutoFilter Field:=5, Criteria1:="On-Hold"
End Sub
Sub Transferred()
'
' Transferred Macro
'


'
ActiveSheet.Range("$A$9:$E$134").AutoFilter Field:=5, Criteria1:= _
"Transferred"
End Sub
Sub Chat()
'
' Chat Macro
'


'
ActiveSheet.Range("$A$9:$E$148").AutoFilter Field:=4, Criteria1:="Chat"
End Sub
Sub Phone()
'
' Phone Macro
'


'
ActiveSheet.Range("$A$9:$E$148").AutoFilter Field:=4, Criteria1:="Phone"
End Sub
Sub Self()
'
' Self Macro
'


'
ActiveSheet.Range("$A$9:$E$148").AutoFilter Field:=4, Criteria1:= _
"Self-service"
End Sub
Sub Clear()
'
' Clear Macro
'


'
ActiveSheet.ShowAllData
End Sub

 

[steve the fish]

You use ActiveSheet.Unprotect at the start and Activesheet.Protect at the end of the code.

 

[Joe4]

Add code to the top of your macro to first unprotect the worksheet.
Then add code in at the end of your macro to re-protect it.

The lines of code you need to do that can be seen here: https://www.mrexcel.com/archive/vba/protect-and-unprotect-worksheet-using-macros-vba/