Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A quick solution may be hiding the columns/rows you don't want to be public,
and then protecting the sheet. Only the users who know the password will be able to unhide the data. Miguel. "Jelinek" wrote: I have a workbook with 3 sheets 2 of the sheets are for general use but one of the sheets i would like people to access only by a password is this possible? i can protect the sheet but i would like only certain people to view the information? protecting stops people from amending/entering data. Thanks Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
how do I restrict access to only one worksheet in excel? | Excel Discussion (Misc queries) | |||
insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |