Thanks to Dave Peterson I was able to set up my survey form. I am now trying
to insert a submit button with a macro to have the survey forms return
directly to me once completed. I used Ron de Bruins €˜send the
ActiveWorkbook. I set all this up at home then emailed the sheet to myself
at work. When I opened the macro at work it appeared to have created another
email macro which was in a hidden workbook. Even though I couldnt find it I
managed to work around it. Anyway I emailed my survey to a work mate so we
could do a test run using the submit button attached to the macro created by
Ron. Perfect, everything worked fine the sheet came back to me as I had
wanted.
Because of the type of information I needed to collect from different areas
I commenced building further survey forms (60 in all). When I went back into
work this morning I sent another survey to the same colleague for another
trial and the submit button would not work with the comment that it couldnt
find the macro. I had assigned the button to the macro. I sent another with
the same result. The macro was there but it seemed as though the macro had
detached itself from the button. I sent the form home to myself so I could
work on it and when I opened it up at home there were no macros at all they
had all completely disappeared. I am sorry this is so long and drawn out but
I wanted to give you as much info as possible. Any help would be greatly
appreciated.