macro hide unhide upon open based on cell value

**aehartle** · 12-28-2010, 01:41 PM

I posted before and no one got back with me...so i created a test workbook. In the workbook you can see that in row 6 there are numbers. If the number is less than 0 i want the macro to automatically unhide the columns, if the number is higher than 0 i want it to keep hidden or hide the column. The number is calculated on the "Now" function and the date i have in row 7. Please help. I would like the macro to run upon opening the workbook.

**Conor** · 12-28-2010, 01:44 PM

this is probably not terribly difficult, but you'll get a much faster response if you post in the programming forum, not general.

**aehartle** · 12-28-2010, 01:57 PM

is ther a way to just transfer it over there or will i have to repost?

**Alf** · 12-28-2010, 02:53 PM

Perhaps something like this?

There is also i macro called "Unhide_Columns" in the workbook. Run this to unhide.

HTH

Alf

**aehartle** · 12-28-2010, 03:26 PM

Ya this will work....Thanks!!1

**Alf** · 12-28-2010, 04:59 PM

Glad to be of help and if this solves your problem could you please mark your thread "Solved" and if you like to give me a pat on the back click on my scale icon and give my answer a rating.

Alf

**Alf** · 12-29-2010, 02:07 AM

Hi again

Could you please change the macro

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

as the last code is taking in account the columns that are actually used in the worksheet.

Alf

**Alf** · 12-31-2010, 03:51 AM

It seems like a "never ending story" but I found a fault of the logic in the Auto_Open macro.

Colums that were hidden will not be unhidden as time passes. So I've changed the macro to this:

Please Login or Register  to view this content.

and that should fix the problem.

So cell values greater than 0 or less than 0 is taken care of. What about cell values equal 0? Will that ever happend and if so what action should be take?

Alf