Anything more annoying than an over-zoomed Excel tab with visible gridlines?
Hating the thought of having to adjust those manually for every single tab in your workbook(s)?
No worries!
The solution is as simple as 10 lines of super versatile VBA code đŸ˜‰
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub RemoveGridlines() | |
Dim Wks As Worksheet | |
'-------------------------------- | |
'written by Angelina Teneva, 2014 | |
'-------------------------------- | |
For Each Wks In ActiveWorkbook.Worksheets | |
If Wks.Visible = True Then Wks.Activate | |
With ActiveWindow | |
.DisplayGridlines = False | |
.Zoom = 80 | |
End With | |
Next Wks | |
End Sub |
Happy VBA coding!