Sub unhide_specific_worksheets()
Dim abc()
Dim wk As Worksheet
Dim i As Integer
abc = Array(Sheet1, Sheet2)
For i = LBound(abc) To UBound(abc)
For Each wk In ThisWorkbook.Sheets
If wk.Name = abc(i) Then
wk.Visible = xlSheetVisible
Exit For
select sheets tab with control button and press alt h h
On 28 Sep 2013 13:04, ashish koul koul.ash...@gmail.com wrote:
Sub unhide_specific_worksheets()
Dim abc()
Dim wk As Worksheet
Dim i As Integer
abc = Array(Sheet1, Sheet2)
For i = LBound(abc) To UBound(abc)
For Each wk In
Do we also have any specific macro for hiding few selected columns?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: 28 September 2013 13:04
To: excel-macros
Subject: Re: $$Excel-Macros$$ how to unhide multiple sheets