Jun 15, 2006 #1 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
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
Jun 15, 2006 #2 AnotherHiggins Technical User Nov 25, 2003 6,259 US 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. Upvote 0 Downvote
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.