ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change / Remove Border from ActiveCell (https://www.excelbanter.com/excel-programming/399680-change-remove-border-activecell.html)

luchshel

Change / Remove Border from ActiveCell
 
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

Chip Pearson

Change / Remove Border from ActiveCell
 
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" wrote in message
...
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




All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com