VBA to hide/unhide rows & columns on multiple sheets

[Adam23]

Hi all,

I have attached a file that represents what I am currently using to day and what I would like to accomplish.

Currently, I have a macro in the input worksheet that will hide or unhide rows and columns within that worksheet.

The worksheet currently works as a table where a user can input some age and salary information for four people. The user can select the term of the model from 1-7 years in cell D2 and columns E:K will hide/unhide depending on the term selected.

There is an option for the user to add an additional person to the model by adding a name in cell C17, which will unhide rows 18 and 19 so the user can enter the age and salary for that person.

I would like a way to have cell D2 and C17 hide/unhide rows and columns on the input tab and the results tab.


The current code that I am using is:

Please Login or Register  to view this content.

Example file.xlsm


Any help is greatly appreciated!

thanks,
Adam23

[mehmetcik]

Change your original to this:-

Please Login or Register  to view this content.

Add these into a normal macro module

Please Login or Register  to view this content.

[Adam23]

Thank you mehmetcik for your help with this!

I'll give this a try and let you know the results!

[mehmetcik]

Make sure you use the latest version.

It is now fully debugged.

[Adam23]

Thanks again for your help with this, but can you please help me a little more...

I have updated the code in the input worksheet to what you provided above and have created a module and added the second code that you provided.

Do I need to edit any of the code to make it hide columns on the results worksheet as well? the columns are not hiding in that worksheet when I change the value in input!D2

Right now, changing the value in input!D2 is only hiding columns on the input worksheet.

Did I do something wrong?

Your help is greatly appreciated.

Thank you,
Adam23

[mehmetcik]

My Mistake. For got the +1

Also you need to make sure the columns on the sheets that are to hide / unhide match or modify the code

Please Login or Register  to view this content.

[Adam23]

Works like a charm! Thank you for all your help!