ExcelMadeEasy: Vba remove gridline display in Excel

Vba remove gridline display in Excel

To do it in Excel, here is the answer:

Option Explicit
Sub RemoveGridlineDisplay()
Activewindow.DisplayGridlines =False
End Sub

Description:

a) Line 3 removes display of Gridlines in ActiveSheet.

You can find similar Excel Questions and Answer hereunder

1) Excel 2010 vba replacement of application filesearch in Excel

2) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

3) How to change desktop background in Excel

4) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

5) How do I enter a formula in a cell using VBA (using Relative Reference)?

6) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

7) How can I set FreezePanes in a certain range using VBA?

8) How can I find the number of working days between 2 dates using VBA?

9) How can I copy and rename a WorkSheet using VBA?

10) How can I get users to select a file for processing using my macro?

Here the previous and next chapter