View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike allen[_2_] mike allen[_2_] is offline
external usenet poster
 
Posts: 85
Default unprotecting modules

I have my VBAproject protected from viewing my code. I want to write a
macro that will unprotect it so I can delete some other modules. I have
tried:

sub unprotectproject()
ThisWorkbook.VBProject.vbcomponents.Unprotect Password:="ok"
end sub

it doesn't work, though. anyone know the answer? Thanks, Mike Allen