| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy/paste from Excel to Word without showing gridlines? | Excel Discussion (Misc queries) | |||
| ScatterPlot Major and Minor Horizontal Gridlines not showing | Charts and Charting in Excel | |||
| Why is Excel 07 only showing gridlines on part of the sheet? | Excel Discussion (Misc queries) | |||
| I just want to print an excel sheet showing gridlines with no text | New Users to Excel | |||
| hiding gridlines in selected cell areas | Excel Discussion (Misc queries) | |||
Hybrid Mode
