how can i disable the ability to editing vb and forms

[habbabub]

is there an easy way? rather than distribute an MDE to users.

 

[shadow9449]

is there an easy way? rather than distribute an MDE to users.

Did you try password protecting the project? Press ALT + F11, go to Tools > Properties and click the Protection tab.

SHADOW

 

[boblarson]

is there an easy way? rather than distribute an MDE to users.

The only way to guarantee that they can't edit your forms or vba code is to distribute as an MDE file (and what is so hard about that?). It isn't hard to create one.

 

[habbabub]

awesome!
that takes care of the VB

but im still able to view/edit the forms, tables, querys etc is there additional settings i can change?

 

[shadow9449]

The only way to guarantee that they can't edit your forms or vba code is to distribute as an MDE file (and what is so hard about that?). It isn't hard to create one.

What's wrong with my solution...?

SHADOW

 

[boblarson]

What's wrong with my solution...?

SHADOW

It will put some level of protection to the code, but that won't protect the forms from changing in design view. Plus there are password breakers out there that can easily hack in.

 

[shadow9449]

It will put some level of protection to the code, but that won't protect the forms from changing in design view. Plus there are password breakers out there that can easily hack in.

Ah, yes...I read the question in haste. He posed it as "VB and forms" and I thought he meant the coding behind the forms.

SHADOW