Macro; Hide Columns; VBA

CF Checklist.xlsm

Hi

I've sourced the initial template from the web, then added other elements, one of which is to Hide Columns based on Date (month) selected

However, this is now working - see attached and I can't figure out why

Would be very grateful if someone could have a look and advise...

Let me know when you can

Thanks, Maddy

The worksheet is protected with a password. The easy way out is to unprotect it at the start of the code and protect it again at the end.


Regards, TMS

OK, two problems, potentially: 1) you are comparing a date value in the cell to a text string in the code and 2) you are, in all cases, comparing cell C1 rather than a cell in the column with a date in it.

So you need something like:

Please Login or Register  to view this content.

So, in the last example, you would need to change C1 to H5 and add the DateValue function around the text date.

You may or may not have to unprotect the sheet depending on how you have set up the protection.


Regards, TMS

Oh, and you'd probably be better looping through the range than doing the long IF THEN ELSE ... bit tedious and repetitive.


Actually, a follow up on the previous post: should actually be comparing the value in cell F5, G5, H5, etc with the value in cell D1 ... not a fixed text value.


Regards, TMS

Like this:

Please Login or Register  to view this content.

Regards, TMS

Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.