how to hide worksheet using VB

[associates]

hi,

I was wondering if anyone might be able to help me. how do i hide
worksheet using VB in excel?

The following is my code that doesn't work.

worksheets("Sheet2").entirecolumn.hide = true

Thank you for your help

 

[Nick Hodge]

Like so

Sub HideWorksheet()
Worksheets("Sheet1").Visible = False
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)