Launch macro on single click with toggle

[Dust For Eyes]

Hi guys,

Once again, I call for you help.

I want to launch a macro with a single click of a particular cell to insert a value.

What I also need is that if you click on that cell again the value disappears. So it's a kind of toggle.

So in short: click on cell, value turns up, click on cell again, value disappears.

Can you with your vast knowledge, help a Excel brother out?

[Paul Edwards]

Please read forum rules. All code must be wrapped

Please Login or Register  to view this content.