LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 391
Default VBA code syntax to protect/unprotect VBProject asumming if Password is known.

2003, 2007

Is there a VBA (best VB.NET Visual Basic) way to protect/unprotect an Excel VBA VBProject?

I can do this in VBA for a WB and a Sht but I cannot find information on how to do the same for a
VBProject.

Frankly, many may feel that I am just trying to crack a locked project. Not true. I am just
attempting to set and remove a VBProject password using VBA directly, not via the typical form
approach.

Late last night I thought I saw something that inferred that passwording for XL VBProjects is
handled by only via Access?

If this is not possible, would someone just say that, as I have more time investment that reasonable
in just finding yea/nay possibilities.

If it is possible, consider placing a code example or at least the objects and modifiers used.

Any thoughts appreciated A link would be great. BTW, please no s/w cracking approaches.

EagleOne
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Code to protect/unprotect a sheet using a macro with password FredH Excel Discussion (Misc queries) 5 October 23rd 07 04:49 PM
Macro to protect/unprotect with password Cam Excel Programming 3 July 26th 05 10:36 PM
Please help!!! Using code to password-protect and unprotect... Hawk Excel Programming 6 July 9th 05 10:48 PM
Password - Protect, UnProtect MrAlMackay Excel Programming 5 January 19th 05 07:23 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"