unlock and lock VBAProject
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 |
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 |
unlock and lock VBAProject
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 |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com