PC Review


Reply
Thread Tools Rate Thread

Change / Remove Border from ActiveCell

 
 
=?Utf-8?B?bHVjaHNoZWw=?=
Guest
Posts: n/a
 
      19th Oct 2007
I would like to supress the black border around the active cell in my workbook.
At a minimum I would like it to appear as White. I've been poking around
the board and can not find a solution. Any help would be appreciated.

VBA Novice FYI

Private Sub Workbook_Open()
ActiveCell.BorderAround LineStyle:=xlLineStyleNone
End Sub
 
Reply With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      19th Oct 2007
The Borders properties and the BorderAround method has nothing whatsoever to
do with the range selection border that marks the selected cell(s). As far
as I know, you cannot turn off the selection border and still be able to
select cells.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"luchshel" <(E-Mail Removed)> wrote in message
news:B0E6C715-A8B3-4839-BF09-(E-Mail Removed)...
>I would like to supress the black border around the active cell in my
>workbook.
> At a minimum I would like it to appear as White. I've been poking around
> the board and can not find a solution. Any help would be appreciated.
>
> VBA Novice FYI
>
> Private Sub Workbook_Open()
> ActiveCell.BorderAround LineStyle:=xlLineStyleNone
> End Sub


 
Reply With Quote
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Change ActiveCell paulhunt08@gmail.com Microsoft Excel Programming 1 14th Aug 2006 08:47 AM
Changing the border of one cell s/n change the border of adjacent =?Utf-8?B?Z2phbnNzZW5tbg==?= Microsoft Excel Misc 2 5th Oct 2005 08:35 PM
Body of page appears in Top Border, Left Border and Bottom Border (there is no right border) Michael Edwards Microsoft Frontpage 1 14th Oct 2004 09:46 AM
impossible to change the activecell??? John T Ingato Microsoft Excel Programming 1 10th Nov 2003 07:46 AM
code to change activecell neopolitan Microsoft Excel Programming 2 2nd Oct 2003 09:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:51 AM.