Hide columns automatically based on year and month imputs

Hello everyone! and thank you for your time.

I work as a financial analyst and I have a VBA question. I would appreciate if you can help me.

My goal is for excel to hide automatically certain columns depending on the imputs on two cells, which indicate the YEAR and MONTH desired. I want the DAY to always be the last possible day of the month.

I have google this, and the best solution I have found is:

Please Login or Register  to view this content.

This code works great, but I have two issues. The first one is that it feeds the code with the date in the cell O3 rather than getting the year and month from P5 & P6. To solve this, I have used this formula on the cell O3 =DATE(P5;P6+1;0). The problem I am having now is that when I change either the year or month the colums wont hide until I click on O3 and press enter. I guess the code above requires you to interact with that cell specifically. Changing the value doesn't trigger the code.

The second issue, a minor one, is that I want the month and year imput to be on a different sheet. As this cells are going to be linked to a bunch of sheets.


Can you guys please help me with this? I tried googling it but can't find a solution.

Thank you in advance.


EDIT: I have posted this on another website. Didnt know it was against the rules. The reason I am posting here now is because I couldn't upload a file on the other forum. Thank you.

Try below code

Please Login or Register  to view this content.

you can but need to change the code little bit.

Attach the file

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new, I will do it for you today: https://www.mrexcel.com/board/thread...mputs.1141244/.)

You may understand, but you are required to advise us of the crossposting. Please provide the URL to the other posting. Please read the forum rules you agreed to when you joined this forum.

I provided the link because you are new here. Next time you will be required to do it yourself.

Didnt know it was against the rules.

You should have, though. When you joined, you agreed to abide by them, so you should have read them. Here's a link for your convenience so that you can read them now: https://www.excelforum.com/forum-rul...rum-rules.html

Nobody is being rude to you.

I have not received any messages from you, sorry, otherwise I would have replied. How and when did you send them?

You cannot delete your account, or close it, but you can choose not to use it, if you wish.