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 Chris Miller 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
Dec 31, 2002
3
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
Changing a command button by VBA
Replies
8
Views
649
mikrom
mikrom
feipezi
  • Locked
  • Question
How to resume Project Explorer, Properties and editor arrangement and layout? 1
Replies
2
Views
105
feipezi
feipezi
Walter Cuypers
  • Locked
  • Helpful tip
Changing number format properties of field in a Microsoft Access 2013 Database
Replies
1
Views
78
Walter Cuypers
Walter Cuypers
EliseFreedman
  • Locked
  • Question
Changing source of all pivot tables in a workbook
Replies
8
Views
123
SkipVought
S
JasonEnsor
  • Locked
  • Question
Excel VBA Classes Returning a Field with multiple properties set on it 1
Replies
2
Views
238
JasonEnsor
JasonEnsor

Part and Inventory Search

Sponsor

Back
Top