Posted to microsoft.public.excel.programming

mike allen[_2_] mike allen[_2_] is offline

external usenet poster

Posts: 85

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Public, Private, Event modules, Forms modules,,,	Jim May	Excel Programming	11	October 31st 05 03:12 AM
Basic question - modules and class modules - what's the difference?	Mark Stephens[_3_]	Excel Programming	9	May 8th 05 11:48 AM
When to code in sheet or userform modules and when to use modules	Tony James	Excel Programming	1	December 16th 04 10:02 PM
Unprotecting!	Joseph	Excel Programming	1	August 2nd 04 04:18 PM
Class Modules vs Modules	Jeff Marshall	Excel Programming	2	September 28th 03 07:57 PM

All times are GMT +1. The time now is 12:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us