Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Border lines and colour for All sheets
Hi Everyone,
is it possible to write a macro to run every sheet and just remove border lines and colours for all cells in a sheet for every sheets in a workbook? I know macro is like this but can't really think how I can loop this. Can anyone help? Thanks alot Cells.Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone Selection.Borders(xlEdgeBottom).LineStyle = xlNone Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone Selection.Interior.ColorIndex = xlNone |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Border Colour | Excel Discussion (Misc queries) | |||
Removing border around Check box | Excel Programming | |||
changing colour of cell border | Excel Discussion (Misc queries) | |||
Removing hyperlink without removing the font settings /border sett | Excel Programming | |||
Colour negative border differently | Charts and Charting in Excel |