Replies

BINGO!!!!!
It’s always the small details that escape me. Thank you so much for all of your help Hans, and for your continuing patience.

SME

I’m glad it worked for you but now I am really confused.
I will go back and triple check all the security settings and run a few more test. I must be missing something.
Thank you for all of your help. I hope you don’t feel as if I wasted your time. I’m glad to know the form worked for you. It must be user error on my part.

Warm Regards,
SME

I’m keeping my fingers crossed.
The macro buttons, 3 of them, are supposed to be right above “Client Confidential”. The buttons are 3 pictures. I also left the test button in and that should be to the right of the 3 pictures.

Thank you,
Summer

I took out the autotext and just put the text as you suggested. No change. Would it assist you if I attached the form? I’m not sure if the macro buttons would go with it though.

Thanks,
SME

Hi Hans,

You always seem to be around when I need help =).

I place the form in a shared folder and then log in to the computer using a different log in. I open the form from the shared folder (the warning comes up asking me to accept the macros and I say yes) and the macro buttons are completely gone.

Thank you,
SME

Hi Kim,

When I click the macro button it activates a macro that unprotects the form, performs the action and then reprotects the form. It works great on my own computer.

Thanks,
SME

Good morning,

I made sure the auto text was attached to the document and then protected the document and saved it as a template. When I open the template and run the macro I get an error message that the auto text cannot be found. I unprotect the template and manually add in the macro and then reprotect the document. But when I go to resave the template I have to rename it and the auto text/macro does not follow.

Warm Regards,

Summer

After you said that it actually worked .

But when I unprotect the template and then add the auto text and reprotect the template, I can’t resave the template without losing the auto text. Any Suggestions?

Warm Regards,

Summer

Good Afternoon,

Everything works perfectly, in document form. But when I save it to a template the AddTable macro/auto text gives me an error message. I think it’s because the auto text is saved to my Normal.dot and not the template. When I try to copy the auto text over to the template I get an error message “Cannot attach document to protected template” I can only assume it is referring to the normal.dot.

I tried recreating the form and the auto text, but I can’t get the auto text to save any where else but the normal.dot. I need everything to work in a template and for that template to be mobile.

Please tell me what I am doing wrong.

Warm Regards,

Summer

Thank you both for your suggestions.

Hans, you were correct in your assumption that I did not have my Auto Text entry named “Add Page”.

I’m going to try and apply my new knowledge to the form and will post with an update.

Thank you!

Warm Regards,

Summer

Hi Hans,

Great suggestion, but I don’t think I am implementing it properly because I am getting an error message:
Run Time Error 5941 The requested member of the collection does not exist. or
Run Time Error 5981 Cannot open macro storage

My add a page code now looks like this:

Sub add_page()

If ActiveDocument.ProtectionType wdNoProtection Then
ActiveDocument.Unprotect Password:=”summer”
End If

Dim pass
Dim table_num As Integer
Dim i As Integer

With ActiveDocument.Tables(table_num)
.Select
Selection.Fields.Update
End With

ActiveDocument.AttachedTemplate.AutoTextEntries(“AddPage”).Insert _
Where:=Selection.Range, RichText:=True

If ActiveDocument.ProtectionType = wdNoProtection Then
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _
NoReset:=True
End If

End Sub

I have saved the form as a document template. This is my first time working with Auto Text. Your guidance is appreciated.

Thanks for responding Hans.

This form will be completed by members of my organization but the completed (printed) form will be forwarded to people outside the organization.

Warm Regards,

SME

Okay, I know what I did wrong: I was adding the code to the wrong area. Instead of adding the code to “This Document”, I was creating a new module and adding it there. I didn’t know you could add things to “This Document”. Boy, do I feel silly.

Thanks for all of your help.

SME

Thank you for replying.

Yes, I have tried the above mentioned code and my Macro Security Settings are set to medium. If I open HansV’s example the window pops up…I just can’t get mine to do it.
I even got a book on VBA (So I wouldn’t post the “simple” questions) but I’m still getting stuck. I thought the VBA book would help me through some of the little stuff but it looks like Woody’s Lounge is still the best place for answers.

SME

Good Afternoon,

I’m stuck again on the issue of having the UserForm pop up when the document is first opened. I was able to add all the fields and I can manually show the form. I compared my form to the tester form in this thread and I just can’t figure it out. Any help would be really, really great! I’m on a time crunch (end of the day today). I even bought a “Mastering VBA” book to no avail.

Thank you,
SME