Forum Discussion
DanMcG
Jun 21, 2022Brass Contributor
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