Hi,

I've tried looking for an answer to this and have already asked
another group both without success. Q. Can user input data be
collected in a form in one workbook and sent to a closed workbook.
Colleagues have been able to delete/change data and they have even
deleted the worksheet altogether. To help solve this I would like to
have this information backed up within a seperate location, which if
this can be done will have a side affect of providing an overview of
the whole data group. Ideally this would be a form which sent data to
an internal and external worksheet at same time.

Many thanks in anticipation

Don