| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I update links from .xls sheets to .xlms sheets | Excel Worksheet Functions | |||
| Links between Sheets | Excel Discussion (Misc queries) | |||
| How to update links between wk sheets | Excel Worksheet Functions | |||
| Links between sheets | Excel Discussion (Misc queries) | |||
| how do i find which sheets contain links? | Excel Worksheet Functions | |||
Linear Mode
