View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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