Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how can I keep 2 lines together when page breaks to 2nd | Excel Discussion (Misc queries) | |||
Excel Access and Oracle | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
Why do Excel and Access freeze on the splash page? | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) |