ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Radio Buttons Locked (https://www.excelbanter.com/excel-programming/319118-radio-buttons-locked.html)

Rog[_3_]

Radio Buttons Locked
 
Still working on some recent templates. They are password protected and
contain two radio buttons.

Problem: Once I protect and then save the template, the radio buttons
are useless b/c the error is telling me that "the cell or chart" is
password protected and that I have to enter the password in order to be
able to select the radio button...

OS: Mac OS 9
Softwa Office 2001

Is it possible for me to setup the radio button so that it unlocks and
relocks as the user activates the radio button? Could this be
specifically related to a problem with Mac? Since I am not having the
same problem on XP?

Roger

Dave Peterson[_5_]

Radio Buttons Locked
 
Do you have a linked cell for your option buttons?

Is that linked cell locked on a protected worksheet?

If yes, then unlock the cell or move the linked cell to another worksheet
(hidden?????).

Rog wrote:

Still working on some recent templates. They are password protected and
contain two radio buttons.

Problem: Once I protect and then save the template, the radio buttons
are useless b/c the error is telling me that "the cell or chart" is
password protected and that I have to enter the password in order to be
able to select the radio button...

OS: Mac OS 9
Softwa Office 2001

Is it possible for me to setup the radio button so that it unlocks and
relocks as the user activates the radio button? Could this be
specifically related to a problem with Mac? Since I am not having the
same problem on XP?

Roger


--

Dave Peterson

Dave Peterson[_5_]

Radio Buttons Locked
 
PS. If it was the linked cell causing the trouble, I have the same trouble in
xl2002.

Rog wrote:

Still working on some recent templates. They are password protected and
contain two radio buttons.

Problem: Once I protect and then save the template, the radio buttons
are useless b/c the error is telling me that "the cell or chart" is
password protected and that I have to enter the password in order to be
able to select the radio button...

OS: Mac OS 9
Softwa Office 2001

Is it possible for me to setup the radio button so that it unlocks and
relocks as the user activates the radio button? Could this be
specifically related to a problem with Mac? Since I am not having the
same problem on XP?

Roger


--

Dave Peterson


All times are GMT +1. The time now is 06:32 AM.

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