Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Preventing user input for individual cells
Hi community,
I'am working with Excel 2003 and I'am wondering how to prevent user inputs for individuals cells without locking the whole sheet. For example, if Row B contains cells displaying formula results - dates, numbers, or text - the user should not be able to change cells in B. How can I achive this? - With Data validations? Thanks and cheers Michael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Preventing user input for individual cells
Michael
Basically what you need to do is unlock ALL the cells on the sheet, then lock those cells you don't want the user to be able to change, then protect the sheet. This allows the user to make changes to all the unlocked cells but not the locked cells. HTH Otto "Michael.Tarnowski" wrote in message ... Hi community, I'am working with Excel 2003 and I'am wondering how to prevent user inputs for individuals cells without locking the whole sheet. For example, if Row B contains cells displaying formula results - dates, numbers, or text - the user should not be able to change cells in B. How can I achive this? - With Data validations? Thanks and cheers Michael |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Preventing user input for individual cells
On Jan 29, 10:53 pm, "Otto Moehrbach"
wrote: Michael Basically what you need to do is unlock ALL the cells on the sheet, then lock those cells you don't want the user to be able to change, then protect the sheet. This allows the user to make changes to all the unlocked cells but not the locked cells. HTH Otto"Michael.Tarnowski" wrote in message ... Hi community, I'am working with Excel 2003 and I'am wondering how to prevent user inputs for individuals cells without locking the whole sheet. For example, if Row B contains cells displaying formula results - dates, numbers, or text - the user should not be able to change cells in B. How can I achive this? - With Data validations? Thanks and cheers Michael Otto, thanks for your fast reply -- but how can realize your suggestion? Michael |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Preventing user input for individual cells
By default all cells in a worksheet are locked when sheet protection is
enabled. It is up to you to decide which are to be locked or unlocked when the sheet is protected. FormatCellsProtection is where you would change the "locked" or "unlocked" status. Select all cells and unlock them. Select the cells to be locked and lock them Then ToolsProtectProtect Sheet. Note the selectable options under "allow users to" when protecting. Gord Dibben MS Excel MVP On Thu, 29 Jan 2009 14:53:48 -0800 (PST), "Michael.Tarnowski" wrote: On Jan 29, 10:53 pm, "Otto Moehrbach" wrote: Michael Basically what you need to do is unlock ALL the cells on the sheet, then lock those cells you don't want the user to be able to change, then protect the sheet. This allows the user to make changes to all the unlocked cells but not the locked cells. HTH Otto"Michael.Tarnowski" wrote in message ... Hi community, I'am working with Excel 2003 and I'am wondering how to prevent user inputs for individuals cells without locking the whole sheet. For example, if Row B contains cells displaying formula results - dates, numbers, or text - the user should not be able to change cells in B. How can I achive this? - With Data validations? Thanks and cheers Michael Otto, thanks for your fast reply -- but how can realize your suggestion? Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect cells but allow for user input. | Excel Discussion (Misc queries) | |||
How to restrict user to input only one of multiple cells | Excel Worksheet Functions | |||
Searching cells from user input | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Preventing a user name in comments | Excel Discussion (Misc queries) |