View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.