Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hide worksheets in VB

Status
Not open for further replies.

ahau

Programmer
Apr 19, 2006
51
AU
Hi,

How do i hide a worksheets in excel using VB?. I wrote a code but it didn't work .

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

Thank you in advance
 
Do you want to hide a WORKSHEET or a COLUMN?

Either way, turn on your macro recorder (Tools > Macro > Record New Macro) and do whatever it is you want to accomplish with code.

After you're finished, review the code that was created in the VB Editor.

Post back with specific questions.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top