Converting Excel Files to Adobe Forms

[Hydestone]

I have a spreadsheet that I customize, then convert to an Adobe form, then send out to people outside my organization to fill out and return to me. We then enter their info back into the master spreadsheet.

I save to PDF, then have Adobe convert it to a form. Generally, everything populates as it should, but a bunch of the cells don't left justify properly.

I am not sure if this is an Excel issue or an Adobe issue. Thoughts?

Also, as I write this...I am wondering if it makes more sense for me to add protection to the spreadsheet, and email it to them. I just want them adding rows and changing data without me realizing it.

Thanks in advance!

 

[Hydestone]

I think I might change things up and send them the excel spreadsheet.

I'll set up protection to prevent unwanted modifications to the SS.

It would look something like this....

1. I edit a worksheet and get it ready to go out to people.
2. Then I would copy that spreadsheet into a new Excel file (there are other worksheets in the workbook that i can't share).
3. Then add protection to the worksheet.
4. Then email it to them.

Thoughts on how to write this macro? And how would it be activated? Could I put t button on the sheet to activate the macro...but the button would not copy over with the worksheet to the new workbook?