Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Koila Malik   on Jan 04 In MS Office Category.

  
Question Answered By: Eileen Carr   on Jan 04

Take out the Dim line, refer to Linked cell as a named  range, not as a
variable, ensure both the chackbox and cell A3 are not locked, leaving
something like:

Private Sub CheckBox1_Click()
If Range("LinkedCell") Then
Call Protect
Else
Call Unprotect
End If
End Sub

But why don't you do away with A3 altogether and just examine the
checkbox's value?:

Private Sub CheckBox1_Click()
If ActiveSheet.CheckBox1.Value Then
Call Protect
Else
Call Unprotect
End If
End Sub

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Protect, unprotect sheet from checkbox control Or get search suggestion and latest updates.


Tagged: