| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Only Problem
Hello
I want to make parts of a worksheet read only. However, when I do this it interferes with my code running corretly. In particular, I get an error each time I try to assign... Selection.Interior.ColorIndex = 50 Is this a bug in Excel or can I get around this? I have 'unlocked' the cells on my worksheet that I want to be able to be manipulated by a user, and left the rest as locked so that they cannot be maipulated. I hear that you can write code along the lines of... Application.Protect UserInterfaceOnly = False ....to protect wroksheets. May this approhch be of more assitance? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counter problem(you really want to read this) | New Users to Excel | |||
| counter problem(you really want to read this) | New Users to Excel | |||
| Open as read only Problem | Excel Worksheet Functions | |||
| Read-only problem | Excel Discussion (Misc queries) | |||
| Addin in read-only mode problem | Excel Programming | |||
Threaded Mode
