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

showing / hiding gridlines through VB code
 

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

showing / hiding gridlines through VB code
 

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" skrev i melding
...
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

showing / hiding gridlines through VB code
 

Morning Archeti,

Gridlines are a property of the Window object, so:

Application.ActiveWindow.DisplayGridlines = False

Best regards

John

"archeti" wrote in message
...
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

showing / hiding gridlines through VB code
 

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