hide and unhide columns based on cell value

**darijokesar** · 11-27-2014, 10:46 PM

I was wondering if somebody can help me with VBA code to automatically hide certain rows based on a cell value. I want to hide columns Q, T and AC if cell E2 shows one of these names: Fantasy, Fascination, Inspiration, Paradise....However, I would like to unhide these columns if user sets E2 cell to show: Breeze, Conquest, Dream, Magic...

Also, sheet is protected and workbook structure as well

Thank you

**Crooza** · 11-27-2014, 11:41 PM

Here you go try this

Please Login or Register  to view this content.

**Crooza** · 11-27-2014, 11:44 PM

Oh and Welcome to the forum

**darijokesar** · 11-28-2014, 03:24 AM

Thank you for welcome and fast response, much appreciated. I moved your code to sheet module but nothing happens..what am I missing here? It does not give me any code errors but doesn't do the job either.

**Crooza** · 11-28-2014, 04:10 AM

It might be the fact that your sheet is protected. Have you tried up protecting and running. If that works we'll work out how to do this in the macro. If it doesn't work are you able to post your worksheet up?

**darijokesar** · 11-28-2014, 08:07 PM

Test.zip

OK, hope attachment will go through. I have left workbook structure unprotected as well as Day 1 sheet. If you can help me hide last two columns in Day 1 sheet we can work from there. Couple of things...first, E2 cell gets value based on C1 cell in Cover sheet. Second, C2 cell is data validated. If you need password...3655

**Crooza** · 11-29-2014, 12:27 AM

Sorry, Can't open zip file.

**darijokesar** · 11-29-2014, 01:33 AM

TestNew.xlsm

OK, I have removed several sheets to make doc under 1MB...disregard Cover sheet formula errors, we need Day 1 sheet anyways

Thank you for your time, much appreciated

**Crooza** · 11-29-2014, 02:12 AM

Ok I've got on another computer and have opened your first zip file.

First issue is on day 1 sheet the value is in C2 not E2 because it looks like you've merged cells.

But I'm getting a few weird results so bear with me while I work on it

**Crooza** · 11-29-2014, 03:30 AM

Try this

Delete the last on I sent you and replace with this one in each sheet you want to hide or unhide columns. This will hide column AC at the moment

Please Login or Register  to view this content.

**darijokesar** · 11-29-2014, 03:37 AM

Well, I tried with C2 as well but no luck

. I even tried with CASE statements but still no desired resault

**darijokesar** · 11-29-2014, 03:44 AM

..now looking at you change select command to AC2 it it makes sense...it works like a charm..I cannot thank you enough

**Crooza** · 11-29-2014, 03:51 AM

Whew. Glad it worked

hide and unhide columns based on cell value

LinkBack

Thread Tools

Rate This Thread

Display

hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Re: hide and unhide columns based on cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hide/Unhide columns based on the value of the cell help!

[SOLVED] Hide/Unhide Columns based on Cell Value

Hide/Unhide columns based on value of a cell

Hide & Unhide columns based on a cell value

[SOLVED] Hide or Unhide certain columns based on a cell value

Bookmarks

Bookmarks

Posting Permissions