Hi guys. I'm very new to VBA so excuse my childish questions. I have he following issue.
I got two worksheets named "Form" and "Data". Both are password protected and "Data" is also hidden.
I need to hide or show a shape (let's call it "Rec 1") placed in "Form" sheet. The condition is that the value of Cell C22 in "Data" sheet is "---".
C22 gets its values via a Choose( ) command depending on the choice of a combo box (in "Form") so basically it has a formula in it and not a value.
Alternatively
Cell "M_New" (in "Data") is fed by a group of radio buttons located in "Form" sheet. (Possible values are 1 or 2)
Cell "D_New" (in "Data") is fed by a combo box (not activeX) located in "Form" sheet. (Possible values are 1, 2 or 3).
I need the following: When M_New = 1 AND D_New =3 Then Shape "Rec1" (in "Form" sheet) must the Visible Else Hidden.
After that, both sheets must be protected and "Data" sheet Very Hidden.
Can anyone assist?
Thanks
I got two worksheets named "Form" and "Data". Both are password protected and "Data" is also hidden.
I need to hide or show a shape (let's call it "Rec 1") placed in "Form" sheet. The condition is that the value of Cell C22 in "Data" sheet is "---".
C22 gets its values via a Choose( ) command depending on the choice of a combo box (in "Form") so basically it has a formula in it and not a value.
Alternatively
Cell "M_New" (in "Data") is fed by a group of radio buttons located in "Form" sheet. (Possible values are 1 or 2)
Cell "D_New" (in "Data") is fed by a combo box (not activeX) located in "Form" sheet. (Possible values are 1, 2 or 3).
I need the following: When M_New = 1 AND D_New =3 Then Shape "Rec1" (in "Form" sheet) must the Visible Else Hidden.
After that, both sheets must be protected and "Data" sheet Very Hidden.
Can anyone assist?
Thanks
