Password to be able to close a form

[Zheno]

Hey,

I have a small database where i want some of my employees to add information. Some of these are just not that smooth with computers in general so i want to protect my database in some kind.

So my solution was that i do a modal form so they cant click on things around it but its still possible to "close" it down. I want the close button there for my use. what would be nice was if i could protect the close button in some way so that they cant close the form down whenever they please or missclick.

Is there some way to passwordprotect the "close" button.

Or would there be some better way to make the form so its no possible to get inside the database itself?

[royUK]

You can use code to prevent the user closing the form with the red X, then add a button that requires a password before closing.

Please Login or Register  to view this content.

This will probably cause problems closing the workbook. The simplest solution is to make the data sheet very hidden

[Zheno]

You can use code to prevent the user closing the form with the red X, then add a button that requires a password before closing.

Please Login or Register  to view this content.

This will probably cause problems closing the workbook. The simplest solution is to make the data sheet very hidden

Thanks for the help royUK,

I went the simple road tho. Took away the possibility too close down the form with the "X" and added a button, put it to the smallest possible, and transparent and put it in the down left corner. and ofcourse put a "close" macro in it.

Anyway thanks for the help.