| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protected linked cell
I have a checkbox linked to a protected cell so I can't change the value in
it. How do i get it to work without unlocking it? I don't want it to be selected when sheet is protected. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
protected linked cell
"ranswert" skrev i en meddelelse ... I have a checkbox linked to a protected cell so I can't change the value in it. How do i get it to work without unlocking it? I don't want it to be selected when sheet is protected. Hi Unprotect the sheet from the macro, pass the value, then protect the sheet again. sheets(1).unprotect Password:="Pass" range("A1").value=me.checkbox1.value sheets(1).protect Password:="Pass", DrawingObjects:=True, Contents:=True, Scenarios:=True //Per |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
protected linked cell
Is there another way to do this without having to protect and unprotect the
sheet each time the checkbox is checked. "Per Jessen" wrote: "ranswert" skrev i en meddelelse ... I have a checkbox linked to a protected cell so I can't change the value in it. How do i get it to work without unlocking it? I don't want it to be selected when sheet is protected. Hi Unprotect the sheet from the macro, pass the value, then protect the sheet again. sheets(1).unprotect Password:="Pass" range("A1").value=me.checkbox1.value sheets(1).protect Password:="Pass", DrawingObjects:=True, Contents:=True, Scenarios:=True //Per |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked files, one is Password to Modify protected | Excel Discussion (Misc queries) | |||
| Protected Sheet doesn't update linked information | Excel Discussion (Misc queries) | |||
| Opening Protected EXCEL worksheets to update linked data | Setting up and Configuration of Excel | |||
| Opening Protected EXCEL worksheets to update linked data | New Users to Excel | |||
| Opening Protected EXCEL worksheets to update linked data | Links and Linking in Excel | |||
Hybrid Mode
