unlock and lock VBAProject

  • Thread starter Thread starter Lenny_821
  • Start date Start date
L

Lenny_821

Hi All,

I am looking for a code that when the macro is activated it firs
unlocks the VBAProject then "does it thing" and when it's finishe
locks the VBAProject again?

Please help :)

Lenn
 
Hi Lenny

There are no objects or methods for that, so you'd need a "sendkeys"
solution. Search Google for samples. "Sendkeys" is not considered as
reliable, so it may or may not work.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble! Unlocking VBA project. 1
Programmatically Open Locked VBAProject 5
Test for VBAProject Locked from Viewing 2
Locking project with workbook open? 2
Error when adding custom help file to custom function 1
Unlock project for viewing within a macro 3
Destroy VBA code within a macro 5
Prompt for VBAproject password 11

Back
Top