| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Cannot select option buttons when Excel sheet is protected.
I have created a spreadsheet that uses options buttons. It is very important
that when people use the sheet that it remains protected (it has a lot of very complicated formulas). However, when the sheet is protected, it stops the user from being able to select the options buttons. I have unlocked the control for each button, I have unlocked the text for each button, and I have unlocked the cell in which each button resides. Am I missing something, or is this a bug? And if it is a bug, is there a patch? Thanks a lot! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help! Cannot select option buttons when Excel sheet is protected.
The linked cell should be unlocked. -- Jim Cone Portland, Oregon USA "Jenn" wrote in message I have created a spreadsheet that uses options buttons. It is very important that when people use the sheet that it remains protected (it has a lot of very complicated formulas). However, when the sheet is protected, it stops the user from being able to select the options buttons. I have unlocked the control for each button, I have unlocked the text for each button, and I have unlocked the cell in which each button resides. Am I missing something, or is this a bug? And if it is a bug, is there a patch? Thanks a lot! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I select several control buttons at once on an Excel sheet | Excel Discussion (Misc queries) | |||
| Option Buttons vs Sheet Protection? | Excel Discussion (Misc queries) | |||
| DP adjustment using quick menu buttons when sheet protected | Excel Worksheet Functions | |||
| Forms Option Buttons(Can be right mouse selected when sheet is loc | Excel Discussion (Misc queries) | |||
| Option Buttons move after placing on sheet | Excel Worksheet Functions | |||
Linear Mode
