Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I protect a worksheet yet allow editing in Excel 2000
I am creating a spreadsheet for users who are using Excel 2000 and I would
like to protect the worksheet yet still allow users to edit a range of cells in the worksheet. By just applying a password to the worksheet I would have to rely on the other users remembering to put the password back on again once they finished entering their data. I know that this facility is available in later versions of Excel ie €śAllow users to edit ranges€ť and I was wondering if there is a way to replicate it in Excel 2000. |
#2
|
|||
|
|||
You could locate the cells that can be edited and use FormatCellsProtection
and un-tick the locked option. Then when the file is protected only these cells can be changed. -- Loose, fast and on the edge. "jimar" wrote: I am creating a spreadsheet for users who are using Excel 2000 and I would like to protect the worksheet yet still allow users to edit a range of cells in the worksheet. By just applying a password to the worksheet I would have to rely on the other users remembering to put the password back on again once they finished entering their data. I know that this facility is available in later versions of Excel ie €śAllow users to edit ranges€ť and I was wondering if there is a way to replicate it in Excel 2000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect cell numbering format ($) but allow editing? | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
lost my password (worksheet protect) | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |