Synchronize option button

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.
 
T

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.
 
S

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
 
D

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

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?
 
D

dhstein

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

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top