Auto Filter and protection does it work?

M

Mike54

Active Member
Joined
Apr 17, 2002
Messages
258
I wonder if can anyone help me please. I am trying to use auto filter on a worksheet and I also want to use protection so that other users cannot alter the data.
I created the worksheet in Excel XP but but am distributing on Excel 2000 and it won't allow me to protect the sheet and use autofilter. Any ideas please

i.e.
It works on XP but not 2000
Many thanks
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
This should work in XL2000 :-

Private Sub Workbook_Open()

With ActiveWorkbook.Sheets("Sheet1")
.EnableAutoFilter = True
.Protect Contents:=True, userInterfaceOnly:=True
End With

End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Filtering upon opening document without using VB code
Replies
1
Views
261
Joe4
Joe4
W
  • Question
Protected sheet disables macro buttons
Replies
5
Views
381
warda11
W
N
  • Question
Auto Filter Zero in Table Column
Replies
0
Views
180
NateD1
N
S
  • Solved
Macro to reset filters in all tables in entire workbook
Replies
1
Views
307
sspatriots
S
G
  • Solved
VBA to allow grouping +- after reopening of the sheet
Replies
7
Views
801
Greenbehindthecells
G

Forum statistics

Threads
1,215,525
Messages
6,125,325
Members
449,218
Latest member
Excel Master

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top