How Can I Quickly Beautify My Spreadsheet?

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 😉

	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

view raw ForEachWks_BeautifyWks.bas hosted with ❤ by GitHub

Happy VBA coding!