Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2005

Tip: Looking for answers? Try searching our database.

Password protect VBA form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vincent - 18 Feb 2005 12:45 GMT
Passwordprotecting a whole document is one thing. I find lots of help about
this. But what if you want to protect a form:
upon entering password A - form B opens.
upon entering password B - form D would open

Here's what I want to do:
1
After clicking a commandbutton I would want a password protection messagebox
showing up on the screen.
2
After entering the password - evalution
If YES - I would like an already prepared form showing
If No -  The entire document shutting down.

help anyone?

Vincent
Signature


Jonathan West - 18 Feb 2005 14:04 GMT
Hi Vincent,

Comments below

> Passwordprotecting a whole document is one thing. I find lots of help
> about
[quoted text clipped - 7 lines]
> messagebox
> showing up on the screen.

Use an ordinary UserForm for this. it will have a TextBox on it into whuch
the user enters the password. You can prevent the actual password showing by
setting the PasswordChar property of the textbox.

> 2
> After entering the password - evalution
> If YES - I would like an already prepared form showing
> If No -  The entire document shutting down.

You evaluate the password entered, unload the password Userform, and then
carry on with whatever you want done.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.