Active X or Form Controls???

[wisemank]

Please read and assist if you have a solution.... I have worksheets that require a check boxes to hide or unhide Charts or additional worksheets - nice feature! After a (un-repetetive) few clicks and or unclicks the check boxes freak out and the text associated with the check box resize themselves or reposition themselves... ANY IDEA WHY???? OR can I use cell data to do the same function control (eg. If A1="x" then unhide or hide worksheet 1)? this way I can delete the silly check boxes and not lose the functionality. Also have the same issue on either Ver 2007 or ver 2010. Thanks in advanced....

 

[bensonsearch]

Hi,
no idea why it would change, the code behind them may say why.

You can use the cells but they have to "change" but that would work fine.

You use the worksheet change event (vba editor, list on left, double click sheet 1 or 2 whichever its on)

then its a matter of telling it what to do (im sure there is better ways but a start would be

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Sheet1.Range("A1") = "x" Then
'do stuff

Else
'other things
End If
End If
End Sub