| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Synchronize option button
I have an option set to turn calc on and turn calc off. This is in 2 sheets.
Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
If you use checkboxes you can use a common linked cell.
2 checkboxes, 1 on Sheet1, 1 on Sheet2 both using the same linked cell, say, Sheet1!A1. -- Biff Microsoft Excel MVP "dhstein" wrote in message ... I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
Hi,
Why not make a toolbar button and also give it a shortcut key, that way you don't need to clutter up the sheets with option buttons or checkboxes? Sub ToggleCalc() With Application If .Calculation = xlCalculationAutomatic Then .Calculation = xlCalculationManual Else .Calculation = xlCalculationAutomatic End If End With End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "dhstein" wrote: I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
Thanks for your reply. However the user wants the option to be available on each sheet - so that's why we have it on two sheets. So having to change to the other sheet defeats the purpose. "T. Valko" wrote: If you use checkboxes you can use a common linked cell. 2 checkboxes, 1 on Sheet1, 1 on Sheet2 both using the same linked cell, say, Sheet1!A1. -- Biff Microsoft Excel MVP "dhstein" wrote in message ... I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
Sorry, I don't understand you.
Why would you have to change sheets? If you have 2 checkboxes, 1 on each sheet, then the option is available on each sheet. If you use a common linked cell whatever you do to one checkbox will be done to the other checkbox. Isn't that what you wanted? -- Biff Microsoft Excel MVP "dhstein" wrote in message ... Thanks for your reply. However the user wants the option to be available on each sheet - so that's why we have it on two sheets. So having to change to the other sheet defeats the purpose. "T. Valko" wrote: If you use checkboxes you can use a common linked cell. 2 checkboxes, 1 on Sheet1, 1 on Sheet2 both using the same linked cell, say, Sheet1!A1. -- Biff Microsoft Excel MVP "dhstein" wrote in message ... I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
Sorry Biff - I misunderstood. OK - then how do I link the checkboxes? Thanks.
David "T. Valko" wrote: Sorry, I don't understand you. Why would you have to change sheets? If you have 2 checkboxes, 1 on each sheet, then the option is available on each sheet. If you use a common linked cell whatever you do to one checkbox will be done to the other checkbox. Isn't that what you wanted? -- Biff Microsoft Excel MVP "dhstein" wrote in message ... Thanks for your reply. However the user wants the option to be available on each sheet - so that's why we have it on two sheets. So having to change to the other sheet defeats the purpose. "T. Valko" wrote: If you use checkboxes you can use a common linked cell. 2 checkboxes, 1 on Sheet1, 1 on Sheet2 both using the same linked cell, say, Sheet1!A1. -- Biff Microsoft Excel MVP "dhstein" wrote in message ... I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
Nevermind my last post - I figured it out - Thanks for your help
"T. Valko" wrote: Sorry, I don't understand you. Why would you have to change sheets? If you have 2 checkboxes, 1 on each sheet, then the option is available on each sheet. If you use a common linked cell whatever you do to one checkbox will be done to the other checkbox. Isn't that what you wanted? -- Biff Microsoft Excel MVP "dhstein" wrote in message ... Thanks for your reply. However the user wants the option to be available on each sheet - so that's why we have it on two sheets. So having to change to the other sheet defeats the purpose. "T. Valko" wrote: If you use checkboxes you can use a common linked cell. 2 checkboxes, 1 on Sheet1, 1 on Sheet2 both using the same linked cell, say, Sheet1!A1. -- Biff Microsoft Excel MVP "dhstein" wrote in message ... I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Synchronize option button
Good deal. Thanks for the feedback!
-- Biff Microsoft Excel MVP "dhstein" wrote in message ... Nevermind my last post - I figured it out - Thanks for your help "T. Valko" wrote: Sorry, I don't understand you. Why would you have to change sheets? If you have 2 checkboxes, 1 on each sheet, then the option is available on each sheet. If you use a common linked cell whatever you do to one checkbox will be done to the other checkbox. Isn't that what you wanted? -- Biff Microsoft Excel MVP "dhstein" wrote in message ... Thanks for your reply. However the user wants the option to be available on each sheet - so that's why we have it on two sheets. So having to change to the other sheet defeats the purpose. "T. Valko" wrote: If you use checkboxes you can use a common linked cell. 2 checkboxes, 1 on Sheet1, 1 on Sheet2 both using the same linked cell, say, Sheet1!A1. -- Biff Microsoft Excel MVP "dhstein" wrote in message ... I have an option set to turn calc on and turn calc off. This is in 2 sheets. Is there a way that I can set the option button to "off" in sheet 2 when the user clicks it in sheet 1 so that they both show as being in the same state - both on or both off? Thanks for any help on this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option button | New Users to Excel | |||
| Option Button | Excel Discussion (Misc queries) | |||
| Option Button | Excel Discussion (Misc queries) | |||
| Option Button | New Users to Excel | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Linear Mode
