Re: Check boxes & protection

Giganews Newsgroups
Subject: Re: Check boxes & protection
Posted by:  Frederick (fjacks…@berkswellgate.freeserve.co.uk)
Date: Sat, 4 Oct 2003

Rob try using eg.

CheckBox2.Enabled = False to disable the checkboxes and CheckBox2.Enabled
=True to re-enable.

do this for each CheckBox in your Code.

Fred

"rob nobel" <robnob…@dodo.com.au> wrote in message
news:OEoTeAkiDHA.6…@tk2msftngp13.phx.gbl...
> I have 4 check boxes with some code to uncheck 3 boxes if 1 is selected as
> follows:
> If CheckBox1 = True Then CheckBox2 = False
> If CheckBox1 = True Then CheckBox3 = False
> If CheckBox1 = True Then CheckBox4 = False
> If Range("o1") = 0 Then GoTo Finish
> If CheckBox1 = True Then
> MsgBox "If you are selecting a different quarter, make sure you have
> selected the 'Finalise' button for the previous quarter (if that quarter's
> BAS has been completed!)"
> Else:
> End If
> Finish:
> End Sub
>
> I would like to protect this sheet, but  can't seem to do it and still
have
> these checkboxes function (even if I insert the ActiveSheet.Unprotect and
> ActiveSheet.Protect commands into this code).
> Any ideas anyone?
> Rob

Replies

In response to

Check boxes & protection posted by rob nobel on Sat, 4 Oct 2003