Help Protecting a Database

[JChan]

Hi All,

I have just created a Userform and was wondering is it possible to protect the worksheet/sheet so that the data can only be changed when the Userform is used?

I tried protecting the sheet but when i went to use the userform the data could not be entered ...

If anyone could help that would be appreciated!

Cheers

JC

[dominicb]

Good afternoon JChan

The only way I can think of doing this is to have the sheet protected, and the code behind the userform (in say Userform_Activate()) is set to unprotect the sheets once the userform opens, update the cells, reprotect the sheets and then close.

It's messy I know, but I think it's the only way.

HTH

DominicB

[JChan]

Hi DominicB,

i'll give it a go ... Cheers!

JChan

[dominicb]

Hi JChan

No problem - thanks for the feedback.

DominicB