| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i lock individual cells within a worksheet?
Hi Earl, Saw your post and want to ask on how to ungroup a group ranges when it's protected? This is what i need to do, I have a bunch of tabs for each department in one worksheet and i don't want unathorized employees reading specific tabs unless they have the password for it. Once they are in that tab, they need to ungroup the ranges and after that, they can only edit specifc ranges and not all. But unfortunately, i can only protect certain ranges if the worksheet is protected without using the grouping and ungrouping the data, which means i have to show confidential informations to other owner of tabs and it's just that they can only read but not edit. Is there a way that i can protect the sheet from unathorized reader? Or Is there a way to unprotect the sheet so that users can use the group and group function and yet can only edit specific ranges? Thanks, MJ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i lock individual cells within a worksheet?
"MJ" wrote: I would like to be able to do the same in excel. I came to the conclusion I need a true accounting database software package with a good report writer a average finance/accounting professional user can use. That is the correct way to manage security I real database. Excel is a poor Mans Database. Hi Earl, Saw your post and want to ask on how to ungroup a group ranges when it's protected? This is what i need to do, I have a bunch of tabs for each department in one worksheet and i don't want unathorized employees reading specific tabs unless they have the password for it. Once they are in that tab, they need to ungroup the ranges and after that, they can only edit specifc ranges and not all. But unfortunately, i can only protect certain ranges if the worksheet is protected without using the grouping and ungrouping the data, which means i have to show confidential informations to other owner of tabs and it's just that they can only read but not edit. Is there a way that i can protect the sheet from unathorized reader? Or Is there a way to unprotect the sheet so that users can use the group and group function and yet can only edit specific ranges? Thanks, MJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do i Lock individual cells? | Excel Worksheet Functions | |||
| Excel should lock individual cells or range only | Excel Worksheet Functions | |||
| You should be able to lock individual Excel cells | Excel Worksheet Functions | |||
| Is there a way to protect individual cells in a worksheet? | Excel Worksheet Functions | |||
| Can u lock individual cells (those containing formulas) in an Exc. | Excel Discussion (Misc queries) | |||
Linear Mode
