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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

changing VBProject properties....

Status
Not open for further replies.
buba

buba

Technical User
Joined
Dec 31, 2002
Messages
3
Location
US
thanks JustinEzequiel, for your valuable suggestions. they worked.. a final query though - We can lock a project for viewing and assign password to our project, using the 'Project Properties' dialog box. Can the same be done using any VBA coding?
Regards,
Buba
 
Sort by date Sort by votes
I have had success doing something like this (only able to do this from memory, sorry) :

VBProject.Unprotect sPassword
wbRef.VBProject.VBComponents.Remove
wbRef.VBProject.VBComponents("Module1")
VBProject.Protect sPassword

Be warned however. If the activesheet or visible form contains a command button that has

TakeFocusOnClick = true,

the code fails. Set it to false and it works fine.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IcarusHallsorts
  • Locked
  • Question Question
Changing a command button by VBA
Replies
8
Views
1K
mikrom
mikrom
feipezi
  • Locked
  • Question Question
How to resume Project Explorer, Properties and editor arrangement and layout?
Replies
2
Views
313
feipezi
feipezi
Walter Cuypers
  • Locked
  • Helpful tip Helpful tip
Changing number format properties of field in a Microsoft Access 2013 Database
Replies
1
Views
222
Walter Cuypers
Walter Cuypers
EliseFreedman
  • Locked
  • Question Question
Changing source of all pivot tables in a workbook
Replies
8
Views
372
SkipVought
S
JasonEnsor
  • Locked
  • Question Question
Excel VBA Classes Returning a Field with multiple properties set on it
Replies
2
Views
453
JasonEnsor
JasonEnsor

Part and Inventory Search

Sponsor

Back
Top