How to remove all cells border of activesheet in Excel 2000 using VBA?

0 ⤊

How to remove all cells border of activesheet in Excel 2000 using VBA? So I can use it as a report.

2006-08-22 02:07:48 · 1 answers · asked by padam_india 1 in Computers & Internet ➔ Programming & Design

I have to achieve it through Module code of excel 2000.

2006-08-22 02:28:07 · update #1

Runtime I am creating a new worksheet and like to have without borders sheet in excel 2000 using vba

2006-08-22 04:14:26 · update #2

Insert this into a module:

Sub NoBorders()

ActiveWindow.DisplayGridlines = False

End Sub

2006-08-24 06:33:05 · answer #1 · answered by Anonymous · 0⤊ 0⤋