Synchronize option button

[dhstein]

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.

 

[T. Valko]

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.

 

[Shane Devenshire]

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

 

[dhstein]

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]

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?

 

[dhstein]

Sorry Biff - I misunderstood. OK - then how do I link the checkboxes? Thanks.

David

 

[dhstein]

Nevermind my last post - I figured it out - Thanks for your help

 

[T. Valko]

Good deal. Thanks for the feedback!