Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom sheet protection
Select the cells where you want to allow entry and right click on them,
Format=Cells, choose protection and uncheck locked. All other cells should be locked (default) No do Tools=Protect=Worksheet. That should do what you want. -- Regards, Tom Ogilvy "matrix" wrote in message ... I want users to be able to enter data into cells, but not delete or insert rows or columns. I can't seem to get sheet protection to work right. Which options do I select, or is this not possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
View Custom View with Sheet Protection | New Users to Excel | |||
Sheet protection AND custom views | Excel Discussion (Misc queries) | |||
Sheet protection error msg - Unrequested sheet activation | Excel Programming |