UNlock project

[Doug Boufford]

My personal template to hold macros, now shows as "project locked" so I
am unable to change any of my macros. How do I unlock it? I'm not sure
how I ever locked it in the first place!!
When you look at project properties, you see nothing because it is locked.
TIA
Doug

 

[Jonathan West]

My personal template to hold macros, now shows as "project locked" so I am
unable to change any of my macros. How do I unlock it? I'm not sure how I
ever locked it in the first place!!
When you look at project properties, you see nothing because it is locked.
TIA
Doug

Is the project loaded as an add-in, rather than as a document? If so, you
need to open the template as a document in order to edit the VBA.

Do any of the macros in the project open & close other files? If so, this
can cause a lock. Close the template and re-open it, and you should be able
to see the code again.

 

[Doug Boufford]

Is the project loaded as an add-in, rather than as a document? If so,
you need to open the template as a document in order to edit the VBA.

Do any of the macros in the project open & close other files? If so,
this can cause a lock. Close the template and re-open it, and you should
be able to see the code again.

Thanks. It twas the 1st one...
D