View Single Post
 
Old 03-10-2024, 09:35 AM
NitroPress NitroPress is offline Windows 11 Office 2016
Novice
 
Join Date: Nov 2019
Posts: 23
NitroPress is on a distinguished road
Default Macro to toggle strikethrough?

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!
Reply With Quote