Locked VBAproject due to macro fault????
 

Hi all,

I have a VBA project which isn't quite finished (one custom toolba
item missing) but when i left it on friday i locked the project with
password, however, when i tried to open it today it faulted o
auto_open (it looks for the custom toolbar item which isnt created yet
no biggie i thought!) and came up with an error 5,....no problem though
i would look at the project and cure this but it doesnt give me th
option to enter my password it just says its locked and i can click o
so now im stuck!!...........can anyone help with this, i would hate t
lose all my work.

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=26601

Locked VBAproject due to macro fault????
 

Simon,

Try opening the project with macros disabled. Then go into the VBE, unlock
the project and complete your changes.

--

HTH

RP

"Simon Lloyd" wrote in message
...

Hi all,

I have a VBA project which isn't quite finished (one custom toolbar
item missing) but when i left it on friday i locked the project with a
password, however, when i tried to open it today it faulted on
auto_open (it looks for the custom toolbar item which isnt created yet,
no biggie i thought!) and came up with an error 5,....no problem thought
i would look at the project and cure this but it doesnt give me the
option to enter my password it just says its locked and i can click ok
so now im stuck!!...........can anyone help with this, i would hate to
lose all my work.

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=266010