| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable cell entry ?
Hi,
Is it possibe to disable entry with text or nummers in a range of cells, but allow changing cell color in an unlocked cell ? Can it be done with a macro? Hans |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable cell entry ?
On Jul 15, 3:20 pm, "H@C0" wrote:
Hi, Is it possibe to disable entry with text or nummers in a range of cells, but allow changing cell color in an unlocked cell ? Can it be done with a macro? Hans hi, go to tools- protection and protect your sheet. in protection dialogue box check the FORMAT CELLS option. bye, naweed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable cell entry ?
Hi naweed,
Thanks for your response. In Protect sheet I have all unchecked except FORMAT CELLS and SELECT UNLOCKED CELLS. I want SELECT UNLOCKED CELLS checked to be abble to change range color, but then you also can change the cell entry. Regards, Hans |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable cell entry ?
This is not my experience.
I use Format | Format Cells opened Protection tab and unlocked all cells, then locked F1:F10 Then in Tools | Protection, I protected the sheet with these boxed checked: Protect Worksheet...., Select locked, Select unlocked, and Format Cells Now I cannot change any value in F1:F10 but I can format including changing colour. I am using XL2003 for this experiment best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "H@C0" wrote in message ... Hi naweed, Thanks for your response. In Protect sheet I have all unchecked except FORMAT CELLS and SELECT UNLOCKED CELLS. I want SELECT UNLOCKED CELLS checked to be abble to change range color, but then you also can change the cell entry. Regards, Hans |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable cell entry ?
Thanks for the explanation, it works in my xl2002
By the way: interesting web site. Regards On Sun, 15 Jul 2007 10:09:00 -0300, "Bernard Liengme" wrote: This is not my experience. I use Format | Format Cells opened Protection tab and unlocked all cells, then locked F1:F10 Then in Tools | Protection, I protected the sheet with these boxed checked: Protect Worksheet...., Select locked, Select unlocked, and Format Cells Now I cannot change any value in F1:F10 but I can format including changing colour. I am using XL2003 for this experiment best wishes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I disable copy/paste of cells, but allow data entry? | Excel Discussion (Misc queries) | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| NEED HELP - How to disable a cell to restrict data entry | Excel Programming | |||
| Disable hyperlinks on entry | Excel Discussion (Misc queries) | |||
Hybrid Mode
