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

--
Lenny_82
-----------------------------------------------------------------------
Lenny_821's Profile: http://www.excelforum.com/member.php...fo&userid=1517
View this thread: http://www.excelforum.com/showthread.php?threadid=27556

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

Lenny,
Why does it need to unlock the project ?

NickHk

"Lenny_821" wrote in message
...

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