Link to home
Start Free TrialLog in
Avatar of Anne Troy
Anne TroyFlag for United States of America

asked on

Worksheet Event Doesn't Work Excel 2007 VBA

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("D5")) Is Nothing Or Target.Cells.Count > 1 Then Exit Sub
ActiveSheet.Shapes("redflagpic").Visible = False

End Sub

Open in new window


Why doesn't this hide the picture?
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anne Troy
Anne Troy
Flag of United States of America image

ASKER

Good enough. I closed all my files, deleted temps, and restarted Excel. Worked. Hm.
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image
If in doubt always go for IT fix #1
turn it off/turn it on again

:)
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image
Annie,

Sorry, but I have to ask: are you sure macros are enabled?

:)

Patrick