In the VBE, each Microsoft Excel Object has a VBComponent name and a
Worksheet name. Programatically, I can interrogate either the
Worksheets or the corresponding VBComponents. How do I tie the two
together?

Given a VBComponent (that is associated with a worksheet), how do I
determine its associated worksheet name or index?

Given a worksheet, how do I determine its associated VBComponent name
or index?

Thanks


---
Message posted from http://www.ExcelForum.com/