Home |
Search |
Today's Posts |
#1
|
|||
|
|||
protect a protected worksheet
I have got one Excel sheet which is password protected some of the users know
the password , i dont want to allow these users to change some of the columns of the work sheet..but it should be open for me.. |
#2
|
|||
|
|||
Maybe look into just protecting the cells that you do not want to be edited
by anyone else. Password protecting a worksheet is scary since if it gets lost or forgotten it is a bear to get it unprotected. You can make the document read only also. Just some ideas. "darshan" wrote: I have got one Excel sheet which is password protected some of the users know the password , i dont want to allow these users to change some of the columns of the work sheet..but it should be open for me.. |
#3
|
|||
|
|||
Shhhh. Don't tell anyone!
If you need to unprotect a workbook or unprotect a worksheet , you can visit JE McGimpsey's site: http://www.mcgimpsey.com/excel/removepwords.html Lisa wrote: Maybe look into just protecting the cells that you do not want to be edited by anyone else. Password protecting a worksheet is scary since if it gets lost or forgotten it is a bear to get it unprotected. You can make the document read only also. Just some ideas. "darshan" wrote: I have got one Excel sheet which is password protected some of the users know the password , i dont want to allow these users to change some of the columns of the work sheet..but it should be open for me.. -- Dave Peterson |
#4
|
|||
|
|||
Lock the cells that the user's shouldn't change and reprotect the worksheet with
a different password???? darshan wrote: I have got one Excel sheet which is password protected some of the users know the password , i dont want to allow these users to change some of the columns of the work sheet..but it should be open for me.. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enable font color on protected worksheet? | Excel Discussion (Misc queries) | |||
Is it possible to sort a protected worksheet? | Excel Discussion (Misc queries) | |||
How to protect Option button in worksheet | Excel Worksheet Functions | |||
Sorting protected worksheet | Excel Discussion (Misc queries) | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |