Hi DM,



if you protect your VBA code you cannot set any VBA project properties,
unless you first unlock the VBA project manually from the VBA editor
(this is what I suspect you are doing).

But Daniel said:

Please, be assure that the project is not protected at this point.

---
Regards,
Norman



"DM Unseen" wrote in message
oups.com...
Daniel,

if you protect your VBA code you cannot set any VBA project properties,
unless you first unlock the VBA project manually from the VBA editor
(this is what I suspect you are doing).

BTW your VBA projectname should always be *static*, since it is an
object reference as well!! What you want you should encode in a cell or
in the file name or in a custom document property, but not change the
VBA project name at runtime!

DM Unseen