Synchronize option button

  • Thread starter Thread starter dhstein
  • Start date Start date
D

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.
 
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.
 
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
 
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.
 
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?
 
Back
Top