Unprotecting a column with a filter

  • Thread starter Thread starter Mary Collins
  • Start date Start date
M

Mary Collins

I have a payroll file that has filters for various payroll
locations. I protected portions of the worksheet but
would like to have managers filter for their specific
company employees data entry.

I can't seem to unprotect that column and filter.
Can you help
 
Hi Mary

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.
 
If you have Excel XP, worksheet Protection provides a
list of functions that you select to give users access
to. One of these functions is Autofilter (other functions
include the ability to sort, access to Pivot table
reports etc). If you evoke the Autofilter option, users
can access the Autofilter, but if they try to do anything
outside the Autofilter range they will get the
standard "This worksheet is protected" message.

Regards,

Mike
-----Original Message-----
Hi Mary

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.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"Mary Collins" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top