Link to the VB

[McNiwram]

Months ago, I asked about hiding/unhiding multiple sheets
using VB. A link was posted where I could download the
free VB by one of the MVPs. I lost the link. Can anyone
please post the link again here.

cheers

 

[David McRitchie]

Hi .... McNiwram,
This is something that you can find the answer for yourself
and you are probably the only one who would recognize
what you are looking for.

Generally one would put their email address into a Google
Groups Search, but can use the email address or the name
with the email address, since your name is unique you could
use McNiwram in the author field. However, since you said
an MVP answered you you might search for the reply instead
by looking for mvp along with your name (but not as author).

http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100
Search for all words: McNiwram mvp
-- group:*Excel* will be added based on the url used

More information on searching in
http://www.mvps.org/dmcritchie/excel/xlnews.htm

 

[Max]

Maybe you were referring to this?
: http://tinyurl.com/2ra5y
(but I'm no MVP <g>)

 

[Don Guillett]

I just recorded this. Does it help
Sub Macro11()
'
' Macro11 Macro
' Macro recorded 5/12/2004 by Don Guillett
'

'
Sheets(Array("Sheet12", "Sheet1", "Sheet2", "Sheet5")).Select
Sheets("Sheet5").Activate
ActiveWindow.SelectedSheets.Visible = False
End Sub
=====
and to unhide
Sub unhideem()
For Each s In Worksheets
If s.Visible = False Then s.Visible = True
Next
End Sub

 

[McNiwram]

Thanks fellas!
I found the link. Unfortunately, the website is down and
I am unable to download the "Worksheet manager" that Jan
Karel Pieterse did.