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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tarina94 - 10 Dec 2006 19:01 GMT

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.

Reply to this Message

Gord Dibben - 10 Dec 2006 19:14 GMT

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 Format>Hide>Sheet then Protect
the Workbook under Tools>Protection>Protect Workbook and enter a password.

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

Gord Dibben MS Excel MVP

>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.

Reply to this Message