Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make this into a toggle command? [XL2003]
I have a simple script that works only okay when going in one
direction, putting a strikethrough when on a particular line: With Selection.Font .Strikethrough = True End With I needed to be able to have a script firstly, behave in a toggle fashion - i.e., press the button and the strikethrough is applied, press the button and it's taken off. Then it would be good to have this work on any given line one is on that it puts the strikethrough on that line for the 2 columns in that spreadsheet for that line, columns A and B. What code would do this pls? I have only one spreadsheet that applies a border line with various "attributes", I think they'd be called (certain line style, colour, etc.) but it applies to a top border and no amount of working with the code has yielded what I need. I seem to still be a junior at all this even after all this time! <sheepish grin Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toggle or command and how | Excel Programming | |||
Command Button That Will Toggle | Excel Programming | |||
Xl2003: Validation.Add method gives error from Command Button | Excel Programming | |||
Xl2003: Validation.Add method gives error from Command Button | Excel Programming | |||
Toggle command buttons | Excel Programming |