Forum Discussion

DanMcG's avatar
DanMcG
Brass Contributor
Jun 21, 2022

how to open every module (that is currently closed) in a workbook

using VBA, how can i open all modules (code modules) in a workbook

 

 

    For Each objVbComp In ThisWorkbook.VBProject.VBComponents
        If objVbComp.Name Like "M*" Then
            'this prints all modules that begin with M
            Debug.Print objVbComp.Name
            'how can i open this module?
        End If
    Next objVbComp

 

 

?

 

No RepliesBe the first to reply

Resources