Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
radio button on protected worksheet
Is there a way to create a set of radio buttons within a password
protected template so that the "Cell or Chart you are trying to change is protected..." error does not occur when selected by the end user? I want my template to be locked, but I want the users that use the template to be able to select either RadioButtonA or RadioButtonB. Help? |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
radio button on protected worksheet
Hi
It should work. Did you link the buttons to locked cells ? That would be the problem if so. Remove the linking and have macros handle the action. HTH. Best wishes Harald "Rog" skrev i melding ... Is there a way to create a set of radio buttons within a password protected template so that the "Cell or Chart you are trying to change is protected..." error does not occur when selected by the end user? I want my template to be locked, but I want the users that use the template to be able to select either RadioButtonA or RadioButtonB. Help? |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
radio button on protected worksheet
"Rog" wrote in message
... Is there a way to create a set of radio buttons within a password protected template so that the "Cell or Chart you are trying to change is protected..." error does not occur when selected by the end user? I want my template to be locked, but I want the users that use the template to be able to select either RadioButtonA or RadioButtonB. Help? Unprotect the worksheet then select the cell you want them to be able to change Right click Format cells Protection Unselect Locked and click OK Make sure you remove protection from both the cell containing the radio button and the linked cell if they are different. Then protect your worksheet again. |
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
radio button on protected worksheet
yeah, you can get rid of Excel; it isn't meant to be used like this for data
entry. use Access-- you can do things like this a LOT easier "Rog" wrote in message ... Is there a way to create a set of radio buttons within a password protected template so that the "Cell or Chart you are trying to change is protected..." error does not occur when selected by the end user? I want my template to be locked, but I want the users that use the template to be able to select either RadioButtonA or RadioButtonB. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need button to add rows on protected worksheet | Excel Worksheet Functions | |||
Decimal place + - button use in protected worksheet | Excel Worksheet Functions | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
Command button on a protected worksheet | Excel Programming | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |