Filtering a protected spreadsheet

[Guest]

When a spreadsheet is protected, is there anyway to be able to still filter
the data?

 

[Guest]

Are you refering to van Excel spreadsheet?

You would proably get a better response from 1 of the Excel newsgroups. This
news group is fro MS Access, the datbase product.

Rosco

 

[Jamie Collins]

Are you refering to van Excel spreadsheet?

You would proably get a better response from 1 of the Excel newsgroups.

Just in case the OP was looking for a reply about Excel from the MS
Access/Jet perspective, here's a brief summary:

CREATE TABLE XLProtectionPermissions (
ExcelObject CHAR(5) NOT NULL,
CHECK (ExcelObject IN ('Sheet', 'Book')),
HasPassword CHAR(1) DEFAULT 'N' NOT NULL,
CHECK (HasPassword IN ('N', 'Y')),
CanRead CHAR(1) DEFAULT 'N' NOT NULL,
CHECK (CanRead IN ('N', 'Y')),
CanWrite CHAR(1) DEFAULT 'N' NOT NULL,
CHECK (CanWrite IN ('N', 'Y')),
PRIMARY KEY (ExcelObject, HasPassword)
)
;
INSERT INTO XLProtectionPermissions
(ExcelObject, HasPassword, CanRead, CanWrite)
VALUES ('Sheet','N','Y','N')
;
INSERT INTO XLProtectionPermissions
(ExcelObject, HasPassword, CanRead, CanWrite)
VALUES ('Sheet','Y','Y','N')
;
INSERT INTO XLProtectionPermissions
(ExcelObject, HasPassword, CanRead, CanWrite)
VALUES ('Book','N','Y','Y')
;
INSERT INTO XLProtectionPermissions
(ExcelObject, HasPassword, CanRead, CanWrite)
VALUES ('Book','Y','N','N')
;

Jamie.

--