Checkbox value = false to activate macro or code????
Posted by Rick M on July 09, 2001 12:14 PM
I am setting up a form and would like the user to indicate which columns they need to see by clicking check boxes on the opening page. If certain checkboxes have a value of "true" when the user hits the "submit macro button" the macro hides all the columns EXCEPT the ones where the chechbox has a value of "true".
I tried this code to no avail:
If checkbox1.value = false then
Selection.entireColumn.Hidden = True
I assigned this code to my "submit" button.
Any help is appreciated!