Lock a User Form?

[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

 

[Dave Peterson]

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.