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.

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.

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.

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.

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.

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.

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.

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.