Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBAProject Protection with Code, How to??????

Status
Not open for further replies.
Scottflyer

Scottflyer

IS-IT--Management
Mar 15, 2003
4
US
Hi:

I'm NOT interested in Worksheet or Workbook protection/unprotection as I know how to do that well. I'm interested in unprotecting and protecting the locked VBA Project itself that has been password protected from viewing. I want to update code in existing copies of the project using the .Remove and .Import methods from within the code of the project itself. For example:

With VBP.VBComponents
.Remove VBP.VBComponents("Module3")
.Remove VBP.VBComponents("Module5")
End With

Does not work unless the VBA Project (not the workbook or worksheet) is unprotected or open.

Can someone tell me how to unprotect and then protect the project, ideally from within the project? Thanks for any help you can give!

Scott
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
451
remeng
remeng
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
620
combo
combo
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
402
strongm
strongm
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
523
feipezi
feipezi
rf92d
  • Locked
  • Question
Hi referring to thread707-107529
Replies
0
Views
466
rf92d
rf92d

Part and Inventory Search

Sponsor

Back
Top