I need to use VBA to loop through all sheets in a given workbook, and modify a specific procedure in some of them.
The modification script is working fine, and I can identify the sheets easily.
But once I have identified the sheet I then need to get the name of the associated code module.
As I understand it, the code module keeps its original name (i.e. 'Sheet1') even though the sheet itself is renamed. But can I somehow extract that? Or find it in any other way?
/Soren
The modification script is working fine, and I can identify the sheets easily.
But once I have identified the sheet I then need to get the name of the associated code module.
As I understand it, the code module keeps its original name (i.e. 'Sheet1') even though the sheet itself is renamed. But can I somehow extract that? Or find it in any other way?
/Soren