I'm using an Excel worksheet to demonstrate subtraction (with "borrows") to my Maths students. I have a button which crosses out a digit (in a cell), ready to reduce the digit by 1
I can't code the worksheet to clear the "diagonal cell line", ready for the next example
Sounds complicated! but I would appreciate some assistance
thank
Bill

Perhaps:

With Selection
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
End With


--
Jim Rech
Excel MVP
"Bill" wrote in message
...
| I'm using an Excel worksheet to demonstrate subtraction (with "borrows")
to my Maths students. I have a button which crosses out a digit (in a cell),
ready to reduce the digit by 1.
| I can't code the worksheet to clear the "diagonal cell line", ready for
the next example.
| Sounds complicated! but I would appreciate some assistance.
| thanks
| Bill

thanks Jim, will try

Bill

----- Jim Rech wrote: -----

Perhaps:

With Selection
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
End With


--
Jim Rech
Excel MVP
"Bill" wrote in message
...
| I'm using an Excel worksheet to demonstrate subtraction (with "borrows")
to my Maths students. I have a button which crosses out a digit (in a cell),
ready to reduce the digit by 1.
| I can't code the worksheet to clear the "diagonal cell line", ready for
the next example.
| Sounds complicated! but I would appreciate some assistance.
| thanks
| Bill