Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove the border around a text box | Excel Discussion (Misc queries) | |||
remove the border for all series for all charts | Excel Programming | |||
remove flashing border after copying cells, how? | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Remove border line of a few cells | Excel Programming |