Object browser: a member's parent is "Excel" but "Excel" doesn't list it, why?

[makiwara]

Hi! I don't understand a strange thing in object library. I have found a class "WorksheetView"
- but it's not listed in "Excel" nowhere if I click Excel (Excel is the parent it lists)
- however if I right click and show hidden elements, there is an IWorksheetView which is member of Excel
- but IworksheetView has no member like WorksheetView

So what is happening here? Could somebody please help me out? I also don't understand why object library has hidden elements.

Thank you very much for your help, have a nice day!

 

[Ezguy4u]

I feel your pain makiwara. The Object Browser has lots of stuff in it and how is it suppose to help us? I took an on-line course by this excel lady and she devoted a whole section to this. While I have a better idea, I still have questions. All I can say is the beat goes on. We need to keep learning as much as we can about this subject. So, let me explain what I know and see if it gets us pointed in the right direction. This Object Browser falls under the heading of Objects, Properties & Methods. The Object Browser just shows us different parts of different libraries. You don’t show it, but above where you typed worksheetview, Excel it displayed. This is just one of the libraries in that drop-down list. I know you are in the Excel library because the classes and Members windows don’t look like other libraries. If you select VBA from that drop-down list, the windows would look very different. Since you have selected the Excel Library you can see worksheetview. So you are in the Excel library. Now worksheetview is a class or object. The items under Member of, are Property. Now how you use all of this to write code, your guess is as good as mine. Maybe one of the A Students can add some information. All I can do is create more questions.

 

[makiwara]

I was seeing the globals mistakenly, all good.