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

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

"sam" wrote in message
...
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