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

[tarina94]

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.

 

[Gord Dibben]

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