ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help! Cannot select option buttons when Excel sheet is protected. (https://www.excelbanter.com/excel-discussion-misc-queries/214346-help-cannot-select-option-buttons-when-excel-sheet-protected.html)

jenn

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!

Jim Cone[_2_]

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!


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com