Re: Remove lines from group box

J.E. McGimpsey

Guest

Posts: n/a

10th Sep 2003

One way, using VBA (you can use it in a macro or enter it directly
in the VBEs immediate window):

ActiveSheet.Shapes("Group Box 1").Visible = False

In article <0e9301c377a2$fa4ea050$(E-Mail Removed)>,
"Jim" <(E-Mail Removed)> wrote:

> Is there anyway to remove or at least modify the color of
> the line around group box without writing a macro. seems
> odd that the line color pallette is disabled with that
> tool?
>
> If you have to do it in a Macro, how would that be done?
>
> Thanks
> jim

« IF statement help | Re: Tally Unique Numbers? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I Remove lines above a key word, remove the lines below another, and keep the lines between the to key words in a Text File?	Quentin	Microsoft VB .NET	2	20th Apr 2007 07:34 PM
Remove lines from Group Box	=?Utf-8?B?TG9yaSBCdXJ0b24=?=	Microsoft Excel Charting	1	25th Jul 2005 06:50 PM
How to remove graphic lines (both horizontal and vertical lines)?	=?Utf-8?B?Q3JpcyBK?=	Microsoft Word Document Management	1	12th Jul 2005 05:59 AM
Remove Group Box border lines	=?Utf-8?B?VHJ1?=	Microsoft Excel Misc	2	17th May 2004 11:40 PM
Remove Group Box border lines (without using macro)?	Meghan	Microsoft Excel Misc	2	9th Apr 2004 02:32 PM