"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
this appears to work in 2003
<snip
Hope this works out for you.

JL,

Firstly, thanks for taking the time to create this new code.

Sorry for the delay in responding. Part of this delay was due to testing
before trying to explain what I thought was an elusive problem but which I
now realise is a feature of Gord's original code that I hadn't noticed
before.

I found that once a cell has been edited in red, then that cell's format
font is changed to red and further toggling of the new button has no effect
in that cell.

Now that I understand what actually happens it is not a problem, however I
would be interested to know if there is a simple way to modify the code to
give a true toggle on/off action.

Also, before I could get your new code to run, I had to rem out the lines
that create the new button captions because they generated syntax errors -
could this be an Excel 2000 problem?

As one final refinement, could the red also be bold?

Thanks again for your help.

--
Fred