| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect worksheet but allow row deletion
My worksheet is protected and many cells are either locked or unlocked. Rows
A10:A31 are unlocked, however, a user cannont delete any row in the rows mentioned. How can I make this happen? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protect worksheet but allow row deletion
It depends of your Excel version, in Excel 2003, during the protection
process you select: Tools -Protection - Protect Sheet Then check in the Allow all users of this worksheet to Box the Delete Rows option. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Tia" wrote: My worksheet is protected and many cells are either locked or unlocked. Rows A10:A31 are unlocked, however, a user cannont delete any row in the rows mentioned. How can I make this happen? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protect worksheet but allow row deletion
Sorry I forgot to put that I'm using Excel 97.
"Michael" wrote: It depends of your Excel version, in Excel 2003, during the protection process you select: Tools -Protection - Protect Sheet Then check in the Allow all users of this worksheet to Box the Delete Rows option. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Tia" wrote: My worksheet is protected and many cells are either locked or unlocked. Rows A10:A31 are unlocked, however, a user cannont delete any row in the rows mentioned. How can I make this happen? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protect worksheet but allow row deletion
Sorry, that was a bug in Excel 97. You will have to upgrade your software,
which with all due respect that is over 10 years old. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Tia" wrote: Sorry I forgot to put that I'm using Excel 97. "Michael" wrote: It depends of your Excel version, in Excel 2003, during the protection process you select: Tools -Protection - Protect Sheet Then check in the Allow all users of this worksheet to Box the Delete Rows option. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Tia" wrote: My worksheet is protected and many cells are either locked or unlocked. Rows A10:A31 are unlocked, however, a user cannont delete any row in the rows mentioned. How can I make this happen? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect files from deletion | Excel Discussion (Misc queries) | |||
| Protect worksheet from deletion | Excel Discussion (Misc queries) | |||
| Protect formulas but allow deletion of rows? | Excel Discussion (Misc queries) | |||
| protect a file from deletion | Excel Discussion (Misc queries) | |||
| how can I protect workbook on a drive from deletion | Excel Discussion (Misc queries) | |||
Linear Mode
