filter for unlocked cells in protected Excell 2007 sheet

O

olegb

Hi,
I'm struggling to allow auto filter function available for other users in
the Excell 2007 sheet where I need one column stay protected (locked and
hidden).
As soon as I protect this sheet (even with filter function selected and
available) it becomes disabled on any other machine for entire sheet.
This happens in Excel 2007, in Exs 2003 everything works fine.
Any suggestions/advises would be highly appreciated
olegb
 

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

Change cell color in protected sheet 1
Protected cells can't be grouped 1
Sorting a protected sheet 1
Protect formulas which reference to unlocked cells in protected s. 5
Allowing editing locked cells in a protected sheet in excel 1
paste locked cells and unlocked cells in protected sheet 15
Utilizng full AutoFilter features while specific cells are protect 0
allow merging cells in protected sheet 2

Top