Hello,
I am not an infant to excel, but no expert, and I have come across a similar iteration of this question in another post, yet the answer does not clearly depict the question I have.

I have excel 2007. I would like to (perhaps using macros) automatically have the data entry form pop up upon opening the shared spread sheet for any user who opens it.

I would like for any of the users to be able to add new data entries using the form. (So far when the form is pulled up in the shared document, the "new" button is grayed out).

How will I go about adding the auto-open AND ensuring that new data can be entered by all users using a (pw-protected) shared document.

Any and all (precise) help is welcome! Thanks.