Worksheet protection problem

  • Thread starter Thread starter Jayne Cabaniss
  • Start date Start date
J

Jayne Cabaniss

I am using Excel 2000, wanting to protect certain cells, but allow user to
filter using autofilter, etc. and how would I do this?

Thanks,

Jayne
 
Private Sub Workbook_Open()
Worksheets("Sheet1").EnableAutoFilter = True
Worksheets("Sheet1").Protect UserInterfaceOnly:=True
End Sub

Right click on the Excel icon next to File in the menubar
choose view code
paste the code
Alt-Q to go back to Excel

This runs every time the workbook opens. It protects the worksheet and
allows users to use the AutoFilter dropdown lists.
 
Back
Top