| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
granting access to view a worksheet
I created a workbook with 5 sheets for users in my office. However, I only
want certain users to be able to VIEW one or two worksheets. How can I restrict certain users from access to some worksheets? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
granting access to view a worksheet
Have you tried hiding the other sheets?
best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "bwaguespack" wrote in message ... I created a workbook with 5 sheets for users in my office. However, I only want certain users to be able to VIEW one or two worksheets. How can I restrict certain users from access to some worksheets? Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
granting access to view a worksheet
I can hide it, but isnt it just as easy for another user to unhide it? I
want to make sure it is not accessible to the restricted users. "Bernard Liengme" wrote: Have you tried hiding the other sheets? best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "bwaguespack" wrote in message ... I created a workbook with 5 sheets for users in my office. However, I only want certain users to be able to VIEW one or two worksheets. How can I restrict certain users from access to some worksheets? Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
granting access to view a worksheet
In Visual Basic there is a VeryHidden status.
-- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "bwaguespack" wrote in message ... I can hide it, but isnt it just as easy for another user to unhide it? I want to make sure it is not accessible to the restricted users. "Bernard Liengme" wrote: Have you tried hiding the other sheets? best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "bwaguespack" wrote in message ... I created a workbook with 5 sheets for users in my office. However, I only want certain users to be able to VIEW one or two worksheets. How can I restrict certain users from access to some worksheets? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I restrict access to only one worksheet in excel? | Excel Discussion (Misc queries) | |||
| I copied a workbook to a CD. I can only access 1 worksheet. | Excel Discussion (Misc queries) | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Office 2003 will not view interactive Worksheet saved as a web pa. | Excel Worksheet Functions | |||
Linear Mode
