Making an image visible/ invisible as cell selection changes

Hi,

[See attached file]

I am trying to make a 'Help button' image visible or invisible as the user selects cells for which help is available.

I am using the following logic to do so:

1. The cells for which help is available are named ranges e.g. a cell might be named GrossPay.
2. The associated Help image is named'hlp[NamedRange] e.g. the Help image for the above named range would be hlpGrossPay.
3. I am using the sheet's Selection_Change procedure to toggle the visibility state of the Help image as detailed below:

Please Login or Register  to view this content.

The code works fine when I click on any of the relevant named range cells (i.e. for which there is an associated Help image) but when I click on any cell without an associated Help image, the last displayed Help image remains displayed- this is the problem I am trying to fix! I want all of the Help images to be made invisible if the cell on which I click does not have an associated Help image. I've tried a few variations at fixing it but haven't got it yet.

All replies gratefully appreciated.

Hello deadlyduck,

This worked for me. Try it out for yourself.

Please Login or Register  to view this content.

Hi Leith,

Many thanks (yet again) - I will check this out later today and mark it as solved once confirmed it's good!

Brian