Hi,
No matter what I tried...I get this error?
All I need to do it list the sheet names on Sheet 1 in the workbook.
The workbook contains 6 worksheets and 18 chart sheets.
Any ideas??
Looping through ALL sheet types
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Looping through ALL sheet types
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Looping through ALL sheet types
Is the active workbook different from the workbook containing the code? Worksheets("NAVIGATE") refers to the active workbook.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Looping through ALL sheet types
Some more info, if pertinent...
The workbook keeps going into Design Mode, probably due to a myriad of missing library objects.
I did comment out the entire module that caused the issue with design mode, as well as the fact that I disable events in my loop...but still the issue?
TX
Hans... The code is all in one workbook.
The workbook keeps going into Design Mode, probably due to a myriad of missing library objects.
I did comment out the entire module that caused the issue with design mode, as well as the fact that I disable events in my loop...but still the issue?
TX
Hans... The code is all in one workbook.
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Looping through ALL sheet types
What happens if you run similar code in a newly created workbook with a few worksheets and chart sheets?
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Looping through ALL sheet types
The code runs smooth as a babies powdered buttocks...
So the problem is in the source workbook?
I'll see if the "owner" of the workbook can run the code...
So the problem is in the source workbook?
I'll see if the "owner" of the workbook can run the code...
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.