| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Remove lines from Group Box
I've found an answer to group boxes that instructs how to remove the borders
from group boxes by using a macro to hide them. Is this the only way? -- Lori |
|
#2
|
|||
|
|||
|
Lori -
The macro works by setting the .visible property of the group box to false. You could also draw a plain white rectangle with no border, put the group box behind it and the option boxes in front of it, and get the same effect, except the cells behind the rectangle would have to be hidden. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lori Burton wrote: I've found an answer to group boxes that instructs how to remove the borders from group boxes by using a macro to hide them. Is this the only way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate cell row and column | Excel Discussion (Misc queries) | |||
| remove blank lines from an entire spreadsheet | Excel Worksheet Functions | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
| Need to remove hyphen in group of #s | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
