Is there a way to limit access to a page in Excel to one person?
 

Is there a way to limit who has access to a page created in Excel to only the
people who need to have the access? Like perhaps to put a block on it?? Or
fix it so that you have to have a password to gain access to the particular
page??

Any help would be greatly appreciated.

Is there a way to limit access to a page in Excel to one person?
 

What do you consider as a "page"?

What is printed out is usually referred to as a page or pages.

Perhaps you are referring to a particular worksheet.

If a worksheet, you could hide the sheet under FormatHideSheet then Protect
the Workbook under ToolsProtectionProtect Workbook and enter a password.

Users with the password could unprotect the workbook and unhide the worksheet.


Gord Dibben MS Excel MVP

On Sun, 10 Dec 2006 11:01:00 -0800, tarina94
wrote:

Is there a way to limit who has access to a page created in Excel to only the
people who need to have the access? Like perhaps to put a block on it?? Or
fix it so that you have to have a password to gain access to the particular
page??

Any help would be greatly appreciated.

Is there a way to limit access to a page in Excel to one person?
 

A variation of what Gord has suggested would be to place a control (either a
button from one of the control toolbars, or even a text box) that is a "show
hidden sheet" button - the code attached to that button would request the
user's password, and if correct, could then unhide the sheet.

This presumes the same setup as Gord suggested, it just adds a button to
replace the process by which the user would use FormatSheetUnhide to see it.

Remember that Excel passwords, both for workbooks and worksheets are very
easy to "crack" and get around. The tools to do that are readily available
also.

"tarina94" wrote:

Is there a way to limit who has access to a page created in Excel to only the
people who need to have the access? Like perhaps to put a block on it?? Or
fix it so that you have to have a password to gain access to the particular
page??

Any help would be greatly appreciated.