![]() |
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 |
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