Macro to unhide a row and a column

[bluelillies]

Hi everyone

I have two questions. I'm really new to VBA so please give as much detail as possible. I've attached a workbook to this post.

Unhiding rows

I have two companies, company A and company B. I always use company A, but I only use company B in certain situations. If I select a checkbox (in cell E16) then I'm saying, yes I am going to use company B. If I'm using company B, then I want rows 19 and 20 to become unhidden after checking the box in E16. If I uncheck the box, then I want rows 19 and 20 to be hidden.

This is the macro that I currently have and it does the exact opposite of what I want (lol).

What am I doing wrong?

Unhiding columns

Similar to above, if I check E16 and I'm saying that I'm using company B, then I want column F to become unhidden. And if the box remains unticked, then I want column F to be hidden. What macro would I need for that?

Thanks so much!

[mike7952]

Something like this should work

Please Login or Register  to view this content.