Locking sheets with Data filters (Excel 2003 SP3)

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Locking sheets with Data filters (Excel 2003 SP3)

Post by steveh »

Guess who is working with data filters today :grin:

I wanted to lock some large lists to avoid accidental deletion of Hyperlinks and or other data so I highlighted the column headers and made sure that they were unlocked and un hidden but when I protect the sheet it disables the arrows.

I am guessing that you cannot lock it but hopefully, and as usual, you will prove me wrong
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin

User avatar
HansV
Administrator
Posts: 79526
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Locking sheets with Data filters (Excel 2003 SP3)

Post by HansV »

When you select Tools | Protection | Protect Sheet, you'll see a list of items with check boxes. Tick the item "Use AutoFilter". This will enable the AutoFilter arrows on the protected sheet.
Best wishes,
Hans

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Re: Locking sheets with Data filters (Excel 2003 SP3)

Post by steveh »

Thanks Hans
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin