View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default unlock and lock VBAProject

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

"Lenny_821" skrev i melding
...

Hi All,

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

Please help :)

Lenny


--
Lenny_821
------------------------------------------------------------------------
Lenny_821's Profile:

http://www.excelforum.com/member.php...o&userid=15179
View this thread: http://www.excelforum.com/showthread...hreadid=275560