Filter option not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Unable to get the filter option to work after selecting 'Protect and Share Worksheet
Have completed all the steps in relation to Format - Cells, but even though the cells are not locked the filter option can not be use
How can I get this to work?
 
Hi gianni

While you are protecting the Sheet
Tools>Protection>Protect Sheet

Below are the rights that you can allow/Disallow all
users. Check "Use Auto Filter"

regards

-----Original Message-----
Unable to get the filter option to work after
Click to expand...
selecting 'Protect and Share Worksheet'
Have completed all the steps in relation to Format -
Click to expand...
Cells, but even though the cells are not locked the filter
option can not be used
 
Amit
It doesn't seem to give me an option to do this.
I did find the below instructions, but I need to be able to protect more than 1 worksheet and secondly if a change the name of the worksheet it does not automatically change the name in this code. How can I get this to happen?

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
 
In a shared workbook, but you can't change the protection, as you can in
a normal workbook. So, your code won't be able to protect the sheet, and
set UserInterfaceOnly, as the workbook opens.

If you want the AutoFilter to work, you could leave the sheet
unprotected. Perhaps you could add a sheet that contains a copy of the
original list, or one that is linked to the protected sheet.
 
Back
Top