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.
 
Back
Top