Filter & Sheet Protection

  • Thread starter Thread starter Wim Ruepert
  • Start date Start date
W

Wim Ruepert

Is there a way that you can allow a user to use a automatic filter on a
protected worksheet ?
 
Hi Wim

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 (Sheet1)and
allows users to use the AutoFilter dropdown lists.
 
Fantastisch !!
Heel erg bedankt

Wim


Ron de Bruin said:
Hi Wim

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 (Sheet1)and
allows users to use the AutoFilter dropdown lists.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allow users of protected sheet to use macro involving custom filte 3
Enabling Autofilter and Sorting in a Protected Sheet 2
Filters not working on Protected sheet 1
Sorting in a protected sheet 1
Protcting a worksheet with a filter 4
Help with using Auto-filter in a protected Worksheet. 5
Macro to allow auto filter after running password protect 1
How do I protect a range but allow auto filtering in earlier versi 1

Back
Top