Trivial in Word, but this has completely eluded me in Excel, for some reason —




I use strikethrough to keep track of values accounted for elsewhere and frequently strike and un-strike cells in the process. Unlike Word, Excel buries the format control a bit, making it difficult to access and apply/unapply.


I need a simple VBA action/macro that will toggle strikethrough on and off on a selected cell. This could be done with a cell style, but as I apply it to a variety of formatted cells, it needs to work without affecting any other style setting.


Ad(thanks)vance!

The following is already built into Excel :

...oh.


Quite a few 'experts' have failed to have that answer on tap. Thanks!

I would be interested in the VBA code for this, so that I can integrate it in macros. Thx.

A whole cell:
Part of the text of a cell:
In both cases, if the range is multicelled, contiguous or not, all the cells will be affected.

To toggle:

Thanks.


...works perfectly for my needs. Just one of those niggling little things that I've been trying to streamline for a while and couldn't figure out Excel's demands. Or ask the right question, apparently.