Filtering a protected spreadsheet

C

Christine

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

Rosco

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
 
J

Jamie Collins

Rosco said:
Are you refering to van Excel spreadsheet?

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

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.

--
 
Top