Vbscript command's

[#1]

Hello all,

I need to withdraw from the excel gridlines, formula bar and headings vbscript on command, can anyone help?

[m_woolf]

    Set XLApp = CreateObject("Excel.Application")

    Set XLWB = XLApp.Workbooks.Add

    XLApp.DisplayFormulaBar = False

    XLApp.ActiveWindow.DisplayGridlines = False

    XLApp.ActiveWindow.DisplayHeadings = False