| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding specific cells
I have an employee spreadsheet that I need to hide the pay amounts for so
that only I can see them by inputting a password. I don't mind if the rest of the sheet is viewable by others. Is this possible? -- Ashley |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hiding specific cells
Use Protection under the Tools menu. You can password the sheet so a user
would need to know the password to make any changes. Mike "Ashley" wrote: I have an employee spreadsheet that I need to hide the pay amounts for so that only I can see them by inputting a password. I don't mind if the rest of the sheet is viewable by others. Is this possible? -- Ashley |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hiding specific cells
Just be warned that Worksheet Prtotection is not very strong and there are
several passwork breakers readily available. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "mikebres" wrote in message ... Use Protection under the Tools menu. You can password the sheet so a user would need to know the password to make any changes. Mike "Ashley" wrote: I have an employee spreadsheet that I need to hide the pay amounts for so that only I can see them by inputting a password. I don't mind if the rest of the sheet is viewable by others. Is this possible? -- Ashley |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hiding specific cells
The general rule is.......................
If you don't want someone to see the data, don't include it in the workbook. Excel internal security is very weak and passwords easily cracked. Gord Dibben MS Excel MVP On Fri, 6 Jun 2008 14:59:00 -0700, Ashley wrote: I have an employee spreadsheet that I need to hide the pay amounts for so that only I can see them by inputting a password. I don't mind if the rest of the sheet is viewable by others. Is this possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hiding specific cells
hi
another suggestion is that if the data is necessary to your work then you might save that file to a flash drive that you can insert and remove quickly. regards FSt1 "Ashley" wrote: I have an employee spreadsheet that I need to hide the pay amounts for so that only I can see them by inputting a password. I don't mind if the rest of the sheet is viewable by others. Is this possible? -- Ashley |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| qn on counting in drop down menus and protecting/hiding specific worksheets | Excel Worksheet Functions | |||
| help... i might need a macro for this.. (hiding a specific # of ro | New Users to Excel | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Hiding rows if specific cell does not contain key word | Excel Worksheet Functions | |||
| hiding specific columns | Excel Discussion (Misc queries) | |||
Linear Mode
