Permissions to view only certain sheets in Excel
 

Is it possible to use permissions (and/or Information Rights Management in
Excel 2003) to limit a person to access only certain pages in a workbook?
Help sites seem to suggest overall rights to a workbook by function (read,
write, etc.) but do not see a page by page access functionality obvious.

Michael, see if this will help,
http://makeashorterlink.com/?F26B23EAA

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Michael C" <Michael wrote in message
...
Is it possible to use permissions (and/or Information Rights Management in
Excel 2003) to limit a person to access only certain pages in a workbook?
Help sites seem to suggest overall rights to a workbook by function (read,
write, etc.) but do not see a page by page access functionality obvious.

Michael

Pauk has directed you to a couple of good postings with the code to hide
sheets from users.

I want to point out that security in Excel is not too robust for someone
determined to have a look at what you got.

The casual and non-curious users can be kept out but if data is really
sensitive you may re-think your project.


Gord Dibben Excel MVP

On Tue, 15 Mar 2005 18:52:03 -0500, "Paul B"
wrote:

Michael, see if this will help,
http://makeashorterlink.com/?F26B23EAA

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Michael C" <Michael wrote in message
...
Is it possible to use permissions (and/or Information Rights Management in
Excel 2003) to limit a person to access only certain pages in a workbook?
Help sites seem to suggest overall rights to a workbook by function (read,
write, etc.) but do not see a page by page access functionality obviou