Date Activate Column

[andrew_net82]

Hi,

I basically want a column to become active on a set date.

I would like column F dated 31/07/10 to become active on that date same applies for column G and so on.

I would like to use this spreadsheet on weekly basis so I can keep up to date on which members of my football team have paid. If you need a better explanation please contact me.

I would appreciate it if someone could help cheers.

[venkat1926]

TRY THIS

right click sheet1 tab and click view code. in the resulting window copy paste this event code
and save the file

Please Login or Register  to view this content.

here today is 1st August. If today is still 31st july in your locations select sheet1 and see that Fis selected. Otherwise you can type todays date in F1 (for test sake) and click sheet2 and then select shet1 coumn F will be selected. any how on 7th August the column G will be highlighted.

remember this event code works only when you acitvate sheet1. If sheet1 is just open it will not. selecte some other sheet and again back to sheet1

Alternatively you can make this work when you open the workbook. Delete the above macro

open vb editor (click developer-visualbasic).now hit control+R. the project window opens.
find out your file and under that right click "thisworkbook" and click view code.given below in the resulting window copy paste this event code. If you do that on 31st july or 7th august when you open the file the corresponding column will be highlighted.There is one snag(also in the previous solution). By chance or design you choose another cell the column will not continue to be highlighted. So instead of highlighting I have made the event code to color the column

Please Login or Register  to view this content.

You can choose whichever solution you are comfortable with. I would rather prefer the latter code(private sub workbook_open)