Hiding and Unhiding a GROUP / PICTURE embedded in a worksheet

[hans302]

Hi I have a very simple code that I thought would work......

The active cell is either "Yes", "No", Blank, or contains a number (formatted as a date)

I only want the GROUP to be visible when the Activecell is a Number (formatted as a date)

The code works to show the GROUP, but does will not hide the GROUP when the Activecell is "Yes", "no", or Blank using the following code

Hope this is a simple request - Ta Hans

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Your first If statement will always be true. If the cell is Yes, a number, or blank, then it's not No, and if it's No, it's not Yes. Given your stated possible values, you only really need the IsNumeric test to show the shape so remove the rest.

[humdingaling]

Please Login or Register  to view this content.

what is i?