| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect sheet without password?
Hello,
Can I protect individual sheets without a password? I'd like for individuals to only be able to view the sheet that's pertinent to him/her. I understand that if you forget the password, you're had. Thanks, Ellen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect sheet without password?
In general terms -- Not that I know of
A possible solution is via the ThisWorkbook object to create a login for your user and hide all sheets but there sheet/sheets. But this is far from secure "EllenM" wrote: Hello, Can I protect individual sheets without a password? I'd like for individuals to only be able to view the sheet that's pertinent to him/her. I understand that if you forget the password, you're had. Thanks, Ellen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect sheet without password?
I thought as much. Just wanted to get confirmation.
Thanks! "steve_doc" wrote: In general terms -- Not that I know of A possible solution is via the ThisWorkbook object to create a login for your user and hide all sheets but there sheet/sheets. But this is far from secure "EllenM" wrote: Hello, Can I protect individual sheets without a password? I'd like for individuals to only be able to view the sheet that's pertinent to him/her. I understand that if you forget the password, you're had. Thanks, Ellen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| password protect a single sheet | Excel Discussion (Misc queries) | |||
| password protect a single sheet | Excel Discussion (Misc queries) | |||
| Password Protect a Sheet | Excel Discussion (Misc queries) | |||
| How do I password protect hidden sheet? | Excel Discussion (Misc queries) | |||
| Password protect a sheet without Macros | Excel Discussion (Misc queries) | |||
Linear Mode
