Links between VBcomponents and Sheets
 

Paul,

The codemodule is a property of the worksheet:

ThisWorkbook.VBProject.VBComponents.("Sheet1").Cod eModule

HTH,
Bernie
MS Excel MVP

"Paul" wrote in message
...
Each time a worksheet is added to a workbook, a new
VBComponent is added to the relevant VBProject. How does
Excel keep track of the link between the new component, a
memeber of the VBComponents collection, and the sheet, a
member of the Sheets collection? Also, how is the link
between the ThisWorkbook component and the actual
workbook managed? Thanks.

Links between VBcomponents and Sheets
 

Oops, I left an extra . in there....

ThisWorkbook.VBProject.VBComponents("Sheet1").Code Module

--
HTH,
Bernie
MS Excel MVP
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Paul,

The codemodule is a property of the worksheet:

ThisWorkbook.VBProject.VBComponents.("Sheet1").Cod eModule

HTH,
Bernie
MS Excel MVP

"Paul" wrote in message
...
Each time a worksheet is added to a workbook, a new
VBComponent is added to the relevant VBProject. How does
Excel keep track of the link between the new component, a
memeber of the VBComponents collection, and the sheet, a
member of the Sheets collection? Also, how is the link
between the ThisWorkbook component and the actual
workbook managed? Thanks.