Hide sheet based on yes/no cell

**Ace Rimmer** · 03-08-2010, 06:38 AM

Hi, I am trying to hide/unhide a single worksheet based on the yes/no result of a cell in a second worksheet. I'm a VBA newbie but so far I have:

Please Login or Register  to view this content.

This works 90% of the time but every now and again I'll change another cell on the worksheet and it will bin out with an error code. Any help as to what I can change?

**Richard Schollar** · 03-08-2010, 06:44 AM

Move the Address test and Value test to separate lines:

Please Login or Register  to view this content.

Richard

**Ace Rimmer** · 03-08-2010, 06:47 AM

I have no idea why that works but many thanks!

**Richard Schollar** · 03-08-2010, 06:53 AM

The problem (usually) is if more than one cell is changed (ie so Target is more than one cell) - Target.Value then returns an array which will give you a type mismatch error when you compare it against a string (ie "Yes").