Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotect/Unlock Option B uttons
I have a spreadsheet (Excel 2003) in which I have 2 option buttons grouped
together to give an either/or choice. These are linked to a cell which return the result of which one is selected. Another formula references this cell to insert specific information in a second worksheet within the file. I want to protect both worksheets and have unlocked cells where the user needs to enter data. My problem is how can I unprotect/unlock the option buttons. Whatever I try results in an error massage re the sheet being protected. My fornulas work but this will confuse users so I don't want the warning shoing. Grateful for any pointers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotect/Unlock Option B uttons
The option buttons should work if the linked cell is unlocked...
-- Jim "Code Numpty" wrote in message ... |I have a spreadsheet (Excel 2003) in which I have 2 option buttons grouped | together to give an either/or choice. These are linked to a cell which return | the result of which one is selected. Another formula references this cell to | insert specific information in a second worksheet within the file. | | I want to protect both worksheets and have unlocked cells where the user | needs to enter data. My problem is how can I unprotect/unlock the option | buttons. Whatever I try results in an error massage re the sheet being | protected. My fornulas work but this will confuse users so I don't want the | warning shoing. | | Grateful for any pointers. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotect/Unlock Option B uttons
Thanks Jim, I thought I'd tried this but obviously hadn't. Works a treat now
:-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can we unprotect a Excel sheet having password by Save as Option . | Excel Worksheet Functions | |||
Why is the option to unprotect a worksheet 'grayed out' | Excel Discussion (Misc queries) | |||
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
The UNPROTECT option | Excel Worksheet Functions | |||
Unable to unlock protection, Option Grayed out | Excel Worksheet Functions |