How to hidde sheet?

[emilija]

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

 

[Frank Kabel]

Hi
Format - sheet - Hide
in the menu bar

 

[Charles]

Emilija

In your code add


Worksheets("sheet1").Visible = False

this will hide sheet1

HTH

Charles

 

[Bob Phillips]

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)