checkbox hide

Hi, I'm trying to find a macro code to hide/unhide certain/selected cells only using the checkbox. For example, if I tick the checkbox, it will show cells "A4:D9" but when I unchecked it, the mentioned cells will be hidden. Attached is a sample of my query. The shaded parts are the ones...

Hi all, I'll be the first to admit I'm quite new to VBA, but delving into it as much as I can. I've been building a questionnaire & want to be able to hide certain rows based on a certain value of a cell. I have managed this successfully on one sheet within my workbook, however when I copy...

Hi, I am making a workbook for work. I'm using activeX checkbox to hide and unhide certain rows when a checkbox is activated. In the section of hidden rows I have another set of checkboxes. I got the code to hide and unhide them, but if I save the file with them hidden and reopen the file and...

Hi, I created a questionnaire on excel, with Activex check boxes. the checkboxes unhide the rows of the next question, depending on which one you answer. So I have hidden the checkboxes in the same rows as the question, using the 'move and size with cells' option. I set it up and it worked...

Hello, I've been trying to figure out how to loop check boxes to unhide rows in a separate sheet. What i've tried so far from going through the various forums in this site: So basically what i'm trying to do is I have a layout of a storage yard that has 79 units with checkboxes beside them...

I am trying to create a dashboard that will allow me to monitor my monthly sales, expenses, and profit. I have created three different line charts (one for sales, one for expenses, and one for profit). On each chart, each line represents a year (2003 is one line, 2004 another, etc.). Now I...

Hello!! Im Having trouble with my Visual basic code in Excel 2007. I'm using the code to hide two rows which works fine, however my code to hide the check box (second line of code) doesn't work so if anyone can see where I'm going wrong that would be great Sub CheckBox17_Click()...