how to hide worksheet using VB
 

hi,

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

The following is my code that doesn't work.

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

Thank you for your help.


--
associates
------------------------------------------------------------------------
associates's Profile: http://www.excelforum.com/member.php...o&userid=35073
View this thread: http://www.excelforum.com/showthread...hreadid=552130

how to hide worksheet using VB
 

Like so

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


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"associates" wrote
in message ...

hi,

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

The following is my code that doesn't work.

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

Thank you for your help.


--
associates
------------------------------------------------------------------------
associates's Profile:
http://www.excelforum.com/member.php...o&userid=35073
View this thread: http://www.excelforum.com/showthread...hreadid=552130