Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Row Deletion
Gary,
At least in XL 2000, you can overline. You can specify it in Format Cells Borders. There's also an overline button that you can drag onto a toolbar. Go to Tools Customize Commands Format and find the "Top Border" button. The overline will behave the way you want - won't be deleted with the line above. hth, Doug Glancy "GaryZ" wrote in message ... To overline a range of cells as in a SubTotal row (such as E13:M13) , I underline the proper cells in the above row (E12:M12). Strange they have every kind of border line except a line over the cell, but that's another story. The drawback in this approach is that when the user deletes the row above the "overlined" cells (Row 12), the "overline" is also deleted. I need a way to detect such a row deletion (deleting the row above the subtotal), so I may underline the proper cells above the deleted row (E11:M11) so that the SubTotal row again appears to be overlined. Thanks, Gary Z. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detecting Calc On or Off | Excel Discussion (Misc queries) | |||
Detecting a color | Excel Worksheet Functions | |||
Detecting Row Deletion | Excel Programming | |||
Detecting Excel 97 using VBA | Excel Programming | |||
Detecting if AutoFill was used? | Excel Programming |