Thread: VBAProject
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
 
Posts: 233
Default 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