Lock a User Form?

  • Thread starter Thread starter Me!
  • Start date Start date
M

Me!

Hi,

I have set up a user form to act as a splash screen with my company & name.

How do I "lock" the form so no-one can change it?

Many thanks

Jason
 
You can lock the workbook's project.

Open your workbook
Go to the VBE
Select your project
Tools|VBAProject Properties|Protection tab
Check the Lock project for viewing
Give it a memorable password.

But remember, this password, like any password, can be bypassed or broken by
anyone with enough determination or money.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Lock specific drop downs on a Word Document 0
Possible to select a string in a locked cell? 1
lock/unlock controls 0
Turning Data into a Table 1
combo box locked 4
Access Sub form opens before the main form in MS Access 0
Email the form 1
Record Locking 2

Back
Top