View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Remove Protected Macro Code from Excel Module

If you want to turn it off and turn it back on at will, you can use:

tools|Addins (xl2003 menus)
and check or uncheck the Passwords item in that list.

If you want to delete it completely
Close excel
look in your addin folders:
for me (xl2003 and winxp home), it's:
C:\Program Files\Microsoft Office\OFFICE11\LIBRARY

And delete that passwordx.xla file.

Then reopen excel.

If you haven't unchecked the item from the Addins list, excel will yell about
not being able to find that file.

Click through that message.

Then go into the tools|addins
and check that password (or is passwordx) option.

Excel will say that it can't find it and offer to remove it from the list.



TGV wrote:

I just downloaded the excel files in the below mentioned link and i have
opened that file after that if i open a new excel, then a window is opening
with Password 2009 message. i went through the VBA there is one protected
code is present in Project Explorer window with a name of Password2009. But
i am unable to edit or remove the code because it is protected by a password.
So anyone pls suggest me how i can remove that macro from my Excel Module.

http://www.allocator.nl/upload/passwordx.zip

---------------
TGV


--

Dave Peterson