Hi all,

I have a number of worksheets with simple macros for buttons which i would like to run, they work fine when the worksheets are not password protected, but i need all worksheets to be password protected so users are only able to change a certain amount of unlocked cells.

i know from other posts on here the way forwrad should be to put something at the start and end of the macros to unprotect the worksheet with the password and then put the password back on but can someone please help with the exact coding, one of my macros is as follows:

Sub Macro4()
'
' Macro4 Macro
'
Sheets("Master Data").Select
Range("L10").Select
ActiveSheet.ShowAllData
ActiveSheet.Range("$A$10:$FI$102").AutoFilter Field:=4, Criteria1:=Array( _
"BAFO", "Bid", "Go", "Prospect", "Suspect", "="), Operator:=xlFilterValues
ActiveSheet.Range("$A$10:$FI$102").AutoFilter Field:=8, Criteria1:="Yes"

End Sub