How to Remove Gridlines Using VBA

To disable gridlines in Excel automatically using Visual Basic for Applications (VBA), you can follow these steps:

Step 1: Enable the Developer Tab

Go to the “File” menu and choose “Excel Options.”

Select “Customize Ribbons.”

Check the “Developer” box.

Click “OK” to add the Developer tab to your Excel ribbon.

Step 2: Insert a VBA Module

Click the “Developer” tab.

On the far left side, click “Visual Basic.”

In the Project Explorer, right-click the “VBAProject” with your workbook’s filename.

Choose “Insert” from the dropdown menu and then select “Module.”

Step 3: Insert or Paste Your VBA Code

Type or paste your VBA code into the module. You can copy code from external sources as Excel allows pasting code from the internet.

Add a Command Button

Step 4: Return to the Excel document

Click the “Developer” tab again.

Select “Insert,” and under ActiveX Controls, choose “Command Button.”

Double-click the command button to create it.

In the dialog box that appears, type or paste your VBA code, then close it.

Step 5: Run the Macro

Click the “Macros” button in the Developer tab.

Select your macro (in this case, the one that hides gridlines).

Click “Run” to execute the code. This code will hide the gridlines throughout the workbook.

Step 6: Preview the Result

When you open the Excel sheet, you see a cross-section of rows and columns with grey-coloured lines that separate cells. Those gray-colored lines are known as gridlines in MS Excel. The grey color is the default color offered by Microsoft and one can change the color of the gridlines. These Guidelines can be helpful in reading data, but they might become distracting or undesirable when presenting or printing the final document.

Borders and Gridlines are two things that create confusion among users, Borders are customizable and one can change their color, type, and width but the same is not true for gridlines.  

Note: Gridlines are always applied on the whole worksheet or workbook, you can’t apply it on one cell or a set of cells. In this case, borders are applicable.