# VBScript Hide Sheet

**URL:** <https://forum.robusta.ai/t/vbscript-hide-sheet/98>\
**Category:** FAQ\
**Created:** [April 26, 2022, 9:09am UTC](https://forum.robusta.ai/t/vbscript-hide-sheet/98 "2022-04-26T09:09:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilayda.ipar](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robusta.ai/ilayda.ipar/32/56_2.png) [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\
**Post date:** [April 26, 2022, 9:09am UTC](https://forum.robusta.ai/t/vbscript-hide-sheet/98/1 "2022-04-26T09:09:20Z")

</div>

A sheet in Excel can be hidden using the vbscript below.

```auto
Set objXLApp = CreateObject("Excel.Application")
objXLApp.Visible = false
Set objXLWb = objXLApp.Workbooks.Open("C:\Robusta_Project\xxx\xyz.xlsx")
Set oSheet = objXLWb.Worksheets("Summary") 
 
oSheet.Visible = xlSheetHidden			  

objXLWb.save
objXLWb.close false
objXLApp.Quit

Set objXLWb = nothing
Set objXLApp = nothing

```