Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I protect an Excel workbook to allow additions only?
I'm creating a workbood that is a permanent record for my business. Is it
possible to protect it so that additions can be made, but the current information cannot be deleted or changed? |
#2
|
|||
|
|||
Can I protect an Excel workbook to allow additions only?
I don't believe this is possible.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Shorty" wrote in message ... I'm creating a workbood that is a permanent record for my business. Is it possible to protect it so that additions can be made, but the current information cannot be deleted or changed? |
#3
|
|||
|
|||
Can I protect an Excel workbook to allow additions only?
No it's not possible to stop someone who knows a bit about excel and can
lookup things online, it can be done for the average user 1 Select the worksheet, do formatcellsprotection, uncheck locked, now select the part you want to protect, repeat and select locked. Protect the sheet. Or if the cells you want to leave unprotected are smaller than the one you want to protect, just select the cells that you want to be free for editing, uncheck locked protect the sheet -- Regards, Peo Sjoblom "Shorty" wrote in message ... I'm creating a workbood that is a permanent record for my business. Is it possible to protect it so that additions can be made, but the current information cannot be deleted or changed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using excel workbook in word mailmerge | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
When opening an existing workbook, Excel opens but not the workbo. | Excel Discussion (Misc queries) | |||
Excel workbook crashed | Excel Worksheet Functions |