Question Locked

hide a colum in excel then auto unhide on at date

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to hide a colum in excel then auto unhide on at date

Normal use of sheet will have a colum hidden
once a date is reached the hidden colum is then unhidden and now is in use and will remain unhidden.

Cheers

Steve

3 replies

by darryl~

Set a date to the desired date....
Run a function (if date = ??? then the value in the cell = ????) where ??? = your desired dates & values.

See this link for some more info...

http://www.meadinkent.co.uk/datesandtimes.htm

There are many more examples, this was the first Google hit I got.

You could possibly run a macro against the date to unhide the column but sometimes people have macros disabled.

Edited for - check these out also...

http://tinyurl.com/ybfstf7

by darryl~

If you have a few hundred rows in the column you want to hide....

I would probably copy that column to a column to the far right of the sheet....set the text color to white & lock the cells so they can't be selected....then run the function to display the contents from that cell in the cell you desire it to be displayed.

This discussion is closed to new replies.