showing / hiding gridlines through VB code

can anyone kindly tell me if there is any way by which I can change the hide
/ show gridlines property of a workbook through VB code. I guess there must
be a system variable for this.

thanks

To hide gridlines use:

ActiveWindow.DisplayGridlines = False
--
Gary's Student


"archeti" wrote:

> can anyone kindly tell me if there is any way by which I can change the hide
> / show gridlines property of a workbook through VB code. I guess there must
> be a system variable for this.
>
> thanks

Record a macro while doing it manually and you have a good start. It is a
Window-per-worksheet setting, not a Workbookwide setting, which makes it a
little confusing to handle.

HTH. Best wishes Harald


"archeti" <[email protected]> skrev i melding
news:[email protected]...
> can anyone kindly tell me if there is any way by which I can change the
hide
> / show gridlines property of a workbook through VB code. I guess there
must
> be a system variable for this.
>
> thanks

Morning Archeti,

Gridlines are a property of the Window object, so:

Application.ActiveWindow.DisplayGridlines = False

Best regards

John

"archeti" <[email protected]> wrote in message
news:[email protected]...
> can anyone kindly tell me if there is any way by which I can change the
> hide
> / show gridlines property of a workbook through VB code. I guess there
> must
> be a system variable for this.
>
> thanks

thanks to all

"Gary''s Student" wrote:

> To hide gridlines use:
>
> ActiveWindow.DisplayGridlines = False
> --
> Gary's Student
>
>
> "archeti" wrote:
>
> > can anyone kindly tell me if there is any way by which I can change the hide
> > / show gridlines property of a workbook through VB code. I guess there must
> > be a system variable for this.
> >
> > thanks