group box line color

[Patrick]

Anyone knows whether or not it is possible to change the line color (or
remove the line) of the group box (the one on the Forms toolbar, not the
Toolbox one)

Cheers, Patrick

 

[Dave Peterson]

You can hide the lines using some VBA:

Option Explicit
Sub testme()
Dim GB As GroupBox
For Each GB In ActiveSheet.GroupBoxes
GB.Visible = False 'true
Next GB
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Patrick]

thanx for the tip, but for some reasons i aim to have a workbook without any
VBA.

Cheers, Patrick

 

[Dave Peterson]

You can put this code in the workbook, run it and then delete the code.

In fact, you could put this code into a separate workbook, run the code and save
it in a nice spot in case you need it again.