Thu 22 Jan 2009, 15:53Delegate Mike said...
Mike has attended:
Excel VBA Intro Intermediate course
Excel VBA
What is VB code to hide the gridlines on a worksheet?
Mon 2 Feb 2009, 15:52Trainer Carlos said...
RE: Excel VBA
Hi Mike
To hide the gridlines on a sheet the code line is
ActiveWindow.DisplayGridlines = False
Replacing False with True displays hidden grid lines
The ActiveWndow object in this case refers to the active sheet.
You may need to precede it with a
Sheets(SheetName).Select
if the present sheet isn't the one losing the grid lines
Hop this helps
Carlos
