movement limitation and security issues

**bstubbs** · 08-18-2010, 03:18 PM

I need some ideas for a project that I've got.

I have a spreadsheet with one column, containing user names. I don't want the users to be able to change anything in the spreadsheet - in fact, I don't want them anywhere in the workbook or worksheet except for that single column of names. Then, once they've moved to their name, I'll have them click on a button that will bring up a form, allowing them to enter their bid selections. Once that form is completed, the data will then be written to the sheet adjacent to their name and the spreadsheet will close.

I'm looking for ideas on the following subjects:

1. How to keep the users from changing anything and limit their movements to that single column of names?

2. How best to let the userForm (with bids) update the spreadsheet without changing any of the other security settings?

3. How best to implement allowing multiple users to simultaneously enter their bids?

Any ideas would be appreciated.

Bob

**arthurbr** · 08-18-2010, 03:25 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST