VBAProject
It should not just be "not protected at this point"
To let this alway work it should *never* be protected (also just
unlocking your project for editing/debugging does not count as removing
the protection). This is why this cannot work (unless he doesn't want
to protect the workbook at all, but that would be a severe limitation
given it has code). It might also be that the code itsself gives him
trouble though. This is the correct code (which I do not condone in any
way I suspect he is using it;)
Sub altername()
Thisworkbook.VBProject .Name = "Consolidated_Monthly_FB"
End Sub
DM Unseen
|