We have a spreadsheet used by multiple people from within MS Sharepoint.

1st ... I'm looking for a way to generate a message that tells the user that
someone else is in the spreadsheet as soon as they open it. My current plan
is to tell them it's in use & to enter their data then use File Send to to
send it to me for later posting.

All files automatically appear with a "READ ONLY" indicator when we open
them from within Sharepoint, so I can't rely on that as an indicator.

2nd ... I would ultimately like to create some kind of temporary
collection/storage sheet or form that allows users to enter their information
& save it individually until it can be merged with the real spreadsheet.

Preferably something that can be accessed by multiple users & generate
individual docs/sheets -- like Word users clicking a template & generating an
individual doc off the template instead of the template itself.

Does anyone have any idea how I can do either of these things? I've written
some macros & created user forms in Word but nothing in Excel yet.

Thanks for your help!

--
JoAnn