View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John[_88_] John[_88_] is offline
external usenet poster
 
Posts: 205
Default 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