I think you need to add the following VBA code to your macro to account for each subproject in the master project:

Dim SubProj As Subproject

For Each SubProj In ActiveProject.Subprojects


Next SubProj

Give it a try and let us know if it helps.