Show code in...     

  

 

Object Model ExcelApplication Worksheets Worksheet Cells Cell Range
Charts Chart SeriesCollection Series 3DProperties Axis ChartFrame Line Area
PivotField PivotFields PivotTable PivotTables
Style Characters Font Pictures Picture DocumentProperties PageSetup


ExcelApplication Object Reference

ShowHScrollBar Property *

* This feature is not available in
ExcelWriterSE, ExcelWriterLE,
or ExcelWriterFree.

Syntax:
[VBScript]
Property ShowHScrollBar As Boolean (read/write)
Description:

When ShowHScrollBar is set to true (1) (default value), the generated spreadsheet will contain a horizontal scroll bar. Set ShowHScrollBar to false (0) to hide the horizontal scroll bar.

Example:
[VBScript]
xlw.ShowHScrollBar = False

Top


Copyright © 2005, SoftArtisans, Inc.