Question

Locked

hide a colum in excel then auto unhide on at date

By stevesmith27 ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I'm not sure about unhiding a column but you can do this...

by Darryl~ Moderator In reply to hide a colum in excel the ...

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

Collapse -

In addition....

by Darryl~ Moderator In reply to I'm not sure about unhidi ...

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.

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums