How to hide columns containing checkboxes

[lmichaluk]

I am new to excel and have built a form that contains check boxes (form, NOT ActiveX). Can someone tell me how to hide the columns and the check boxes please? As it is now built, when I hide the columns, the squished check boxes show up...
Any help appreciated.
Thanks
Linda

 

[MickG]

You can hide forms checkboxes like this:-

ActiveSheet.CheckBoxes.Visible = False
ActiveSheet.CheckBoxes.Visible = True

Mick

 

[lmichaluk]

Thanks Mick. Sorry, I'm too much of a novice to understand...
The form I have built is a master form that is to be used for two purposes - half of the form (that contains check boxes) will be filled out by one individual. The form, once filled out, will then be sent to another person who will then fill out other elements of the form that also contain checkboxes.
I want to be able to use the master form with the columns that will be filled out by the second person hidden when the form goes to the first person (no secret - just easier to present the info), and then simply unhide those columns (and lock the first set of columns) when the completed form is sent to the second person.
So - if there is a formula I can put in to hide the selected columns with the check boxes, what would the formula be, and where would I put it?
Thanks again.
Linda

 

[MickG]

If you mean a form that's saved as a template, then I'm not familiar with them, and not sure how to intigrate that code in a form of that type.
But if you do find out, that bit of code will remove & reinstate them.
Mick

 

[lmichaluk]

Thanks Mick. I got so wrapped up in the excel stuff that I completly forgot that the form would be a template. Sorry for not being more clear. If I do find out what code will work, I will post.
Cheers
Linda