Looping through ALL sheet types

[Rudi]

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??

2014-03-11_14h30_18.jpg

[HansV]

Is the active workbook different from the workbook containing the code? Worksheets("NAVIGATE") refers to the active workbook.

[Rudi]

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.

2014-03-11_14h55_10.jpg

[HansV]

What happens if you run similar code in a newly created workbook with a few worksheets and chart sheets?

[Rudi]

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...