That worked out great!
I have another question, I have changed a few check Boxes to Form Fields with drop-down comments "Add" "Delete" and I was able to write the code that will mirror the comment from my Select all form field but I was only able to write it for one other individual bookmark, I have a range of form fields 1-15 labeled "LMSI_Office1 - LMSI_Office15" and I was not sure how to write that in code?
Sub CopyField()
Dim Temp As String
Temp = ActiveDocument.FormFields("LMSI_Office1").Result
ActiveDocument.FormFields("LMSI_Office2").Result = Temp
End Sub
Above is my code. I also need to add something to this and don't know how to do it, I need the code to un-protect the sheet before running the macro (No password required) and then re-protect the sheet "protect document for forms" Any idea's on the above question?
The range question would really help out cause manually writing in 15 lines seems like overkill?
Thanks for your help!
|