Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Michael C
 
Posts: n/a
Default 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.
  #2   Report Post  
Paul B
 
Posts: n/a
Default

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.



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default view of Excel to 75% Gaurav Excel Discussion (Misc queries) 10 August 4th 07 11:54 PM
why can't i view the file (excel) that is open? Navarino Excel Discussion (Misc queries) 1 March 2nd 05 07:57 AM
Microsoft Office 2002 Excel sheets Lady Rhyanon Excel Discussion (Misc queries) 0 February 23rd 05 06:27 PM
How do I toggle between sheets in Excel? Bill Hank Excel Discussion (Misc queries) 1 December 22nd 04 05:37 PM
need an advice in excel sheets.... | m o [] Excel Discussion (Misc queries) 0 November 27th 04 11:36 PM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"