OK, I think I see the problem.
I think I need to define some terms for you.
The term "collection" is very descriptive.
It is used to define a "group" of objects.
The images on a sheet are part of a "collection" of images.
A workbook contains a collection of WorkSheets.
The actual term "Sheets" refers to this "Collection".
By default, when a sheet is created, it is given an object identifier
like Sheet1, Sheet2, Sheet3.
But this is not the NAME of the sheet.
Although, by default, Excel makes the NAME of the sheet the same as this
identifier.
But you can change the name.
So, you can say Sheet1.Name = "NewName"
in VBA, you'll see that it is shown as:
Sheet1(NewName)
To refer to a single sheet in the sheet collection, you can say:
Sheet1
Sheets("NewName")
so, let's say you have a new workbook and you want to change the sheet named
"Sheet1"
to "NewName"
you can:
Sheet1.Name = "NewName"
Sheets("Sheet1").Name = "NewName"
or
dim sh as WorkSheet
set sh = Sheet1
sh.Name = "NewName"
-------------------
So, that being said.
you're wanting to loop through the Sheets collection.
The syntax for that is Sheets() where within the () is a sheet NAME or array of
NAMES
So, since you've renamed your sheets, you need to use:
For Each sh In Sheets(Array("Module", "VAL & VOL", "Sheet3", "TRADING RESULTS"))
hope this helps
Paul
-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
________________________________
From: Hilary Lomotey <resp...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Tue, October 30, 2012 3:03:52 PM
Subject: Re: $$Excel-Macros$$ UNHIDING SELECTED WORKSHEET *
Thanks Paul
pls see attached
On Tue, Oct 30, 2012 at 6:56 PM, Paul Schreiner <schreiner_p...@att.net> wrote:
This message is eligible for Automatic Cleanup! (schreiner_p...@att.net) Add
cleanup rule | More info
>
>
>What line is producing an error?
>
>I ran it and it worked fine.
>
>But my sheets weren't password protected.
>At no point in your macro are you "applying" the password to unprotect your
>sheets or workbook.
>
>Since I don't know what kind of Protection you've issued on your workbook and
>sheets,
>it's difficult to test it.
>
>Can you delete all of the data from your sheets and post or email a file
>WITH ANY PROTECTION ENABLED.
>
>And, from your example, I "assume" your password is "password"...
>
>Paul
>-----------------------------------------
>“Do all the good you can,
>By all the means you can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-----------------------------------------
>
>
>
>
>
________________________________
From: Hilary Lomotey <resp...@gmail.com>
>To: excel-macros <EXCEL-MACROS@googlegroups.com>
>Sent: Tue, October 30, 2012 2:44:49 PM
>Subject: $$Excel-Macros$$ UNHIDING SELECTED WORKSHEET
>
>
>
>Hello
>
>
>Kindly assist me to modify this code, i am trying to hide some selected work
>sheet, however, i get a debug error when i use the code below, pls can anyone
>modify this code for me. thanks
>
>
>
>
>
>
>Sub Sheets_Unhide()
>
>
>Dim sh As Worksheet
>Dim myPassword As String
>myPassword = "password"
>If InputBox("Please enter password to show sheets: ") = myPassword Then
> Application.ScreenUpdating = False
> For Each sh In Sheets(Array("Sheet1", "Sheet2"))
> sh.Visible = True
> Next sh
> Application.ScreenUpdating = True
>Else
> MsgBox ("Incorrect password, macro stopping")
>End If
>End Sub
>
>--
>Join official facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES (1120+ members already BANNED for violation)
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
>quick attention or may not be answered.
>
>2) Don't post a question in the thread of another member.
>
>3) Don't post questions regarding breaking or bypassing any security measure.
>
>4) Acknowledge the responses you receive, good or bad.
>
>5) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited.
>
>
>6) Jobs posting is not allowed.
>
>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>owners
>and members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google Groups "MS
>EXCEL AND VBA MACROS" group.
>To post to this group, send email to excel-macros@googlegroups.com.
>To unsubscribe from this group, send email to
>excel-macros+unsubscr...@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>--
>Join official facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES (1120+ members already BANNED for violation)
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
>quick attention or may not be answered.
>
>2) Don't post a question in the thread of another member.
>
>3) Don't post questions regarding breaking or bypassing any security measure.
>
>4) Acknowledge the responses you receive, good or bad.
>
>5) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited.
>
>
>6) Jobs posting is not allowed.
>
>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>owners
>and members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google Groups "MS
>EXCEL AND VBA MACROS" group.
>To post to this group, send email to excel-macros@googlegroups.com.
>To unsubscribe from this group, send email to
>excel-macros+unsubscr...@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
