Secure Data sheet from users

[sam]

Hi All,

I have designed a User form in Excel that would be saved on Shared drive so
multiple users can submit their requests. I have a "Start" Button on Sheet2
that launches the form and the Actual Table where the data will be stored
once the "Submit" button is clicked on user form is on Sheet1. Now, Sheet1
and Sheet2 are in the Same Excel workbook.

My concern is about the security of the data table in Sheet1 where the data
will be stored. Is there any way I can secure just the data table? I tried to
password protect it but doing that, users are not able to submit data through
the user form.

Please Help

Thanks in Advance

 

[Patrick Molloy]

somebody had a query that might resolve this. Your "submit" button could
just email you the data without saving it ... you could have an Outlook Rule
that out any mails witha certain subject into a target folder ..and you
could automate stripping the data from mail in this folder into a
spreadsheet that only you could use.
the mail query was in the last couple of days