Hi Paul

Thank you for nice links and tips about how to write callbacks. Unfortunately my knowledge about VBA is poor, so I should have more specific instructions to get this right.

I’ll try to explain exactly what I have done, so there is no doubt about that.

1. As you assume, I use the MS Office 2007 Custom UI Editor.
2. I am working with Word (I suppose the same things could be done in Excel).
3. With help from great copying, I’ve made a file containing the following VBA-code, who definates a button id, a label and an on action name.


This works perfectly (except from a warning about macro-function when opening Word), and it’s rather good looking, but unfortunately not working.

4. This file is stored in the startup folder for Word.

To understand this better, it would be great help for me to know:

5. Should further code be put into the VBA-code in the file mentioned above, or should it be put into a separate file?
6. If separate file, should this file be designed in the MS Office 2007 Custom UI Editor?
7. If separate file, should this file also be put in the startup-folder, or should it be put somewhere else?
8. If separate file, could I have callbacks for all commands in the same file, or should I have separate files for each command?
9. For all commands, I want to open a Template. I have made templates of a number of documents which are used pretty often. When open these templates (at least by exploring and double-click actual files) I have managed a fill-form to open, and then, with help from bookmarks, the information I state, will be filled into my document at the right places. For example one of these templates could be stored as c:/macro/engagementletter.docx.

Can someone please help me with how this a callback should be designed (sorry, but I probably need it word by word)?


Thanks again for spending your time helping me. I’ll get these books to learn more about VBA, but in the short run, I would be pleased just to make this work.


Best regards
Jan Aage