Running Macros when worksheets are protected

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

thanks Dave i added that in and it works for some macros and the others it keeps coming up with the error 1004 - showalldata method of worksheet class failed and in the macro it is highlighting the following step:

ActiveSheet.ShowAllData

any ideas?

no the macro buttons are in an "overview" tab and the buttons take them to different sections of the "master Data" tab, i think the problem may be to do with autofilters as i am trying to reset all the autofilters at the beginning of each of the macros.

Attachment 228721sorry attachment shoudl now be atatched.

thanks for your help Dave.

thats amazing, i didnt realise some of them were highlighted green and commented out, i have changed them all and they now all work, thanks so much for your help dave!!