PaulFogel123
Member
I have the following code assigned to an object:
>>> use code - tags <<<
This works fine, but when I enable protection, the only options I want to be selected are Sort and Use Autofilter, nothing else. If I first set these manually, the macro above clears all the checkboxes. So I tried recording a macro in which I selected only the two options I want, but still, it cleared every checkbox upon execution. Something is causing this reset but I can't figure out why.
Can you help with the proper code to be inserted into the above?
Paul
>>> use code - tags <<<
Code:
Sub Picture877_Click()
'
' Picture877_Click Macro
'
ActiveSheet.Unprotect Password:="EIS 2017"
Range("G1:L1").Select
Selection.EntireColumn.Hidden = True
Range("G4:BJ4").Select
ActiveSheet.Protect Password:="EIS 2017"
End Sub
Can you help with the proper code to be inserted into the above?
Paul
Last edited by a moderator: