Is it possible: append rights only to Excel worksheet?

[pitaszek]

Hi Guys,

I am working on a form in Excel VBA code of which is password protected. The idea is that user fills the form (accessible from his/hers drive or from remote location), clicks submit button and the email with details is sent.

At the same time the same details are saved into other Excel placed in shared network location as an evidence or for archiving purposes. As various users submit their forms with details which are confidential and should not be seen by other submitters.

Any way to achieve that?
a) can a macro have access to the file but user who attempts to access manually not?
b) is there any channel for one-way connection with append right for every user and execptions for administrator?

Regards,
Witek

 

[yky]

If users don't have the password, they can't access the file. In the macro, you can use unprotect to access the file.