My question is, is it possible to hide sheet (sheet tab, with the name of
the sheet), similar to hiding of rows and columns

Thanks, Emilija

Hi
Format - sheet - Hide
in the menu bar

--
Regards
Frank Kabel
Frankfurt, Germany

"emilija" schrieb im Newsbeitrag
...
My question is, is it possible to hide sheet (sheet tab, with the
name of
the sheet), similar to hiding of rows and columns

Thanks, Emilija

Emilija

In your code add


Worksheets("sheet1").Visible = False

this will hide sheet1

HTH

Charles


---
Message posted from http://www.ExcelForum.com/

Sure

Worksheets("Sheet1").Visible = xlSheetHidden

at least one sheet must be visible

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"emilija" wrote in message
...
My question is, is it possible to hide sheet (sheet tab, with the name of
the sheet), similar to hiding of rows and columns

Thanks, Emilija