Vba remove gridline display in Excel

To do it in Excel, here is the answer:

  1. Option Explicit
  2. Sub RemoveGridlineDisplay()
  3. Activewindow.DisplayGridlines =False
  4. End Sub


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