You could just write a coverall save macro, which could be added to the toolbar, and hence be made as easy as saving a document. I don't see any real reason why such a Macro couldn't cover all the software components you've mentioned. David. -----Original Message----- From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pranav Lal Sent: 16 December 2010 13:42 To: program-l@xxxxxxxxxxxxx Subject: [program-l] Writing a program to prompt for data classification Hi all, I have been asked to write a program that prompts the user to add or edit data classification labels when a document is saved with any changes. I need to cover Microsoft Word documents, Excel workbooks and PowerPoint presentations. So, the user will close or save a file. If it is a new document, the program will prompt the user to assign a label like "confidential", "internal" or "public." Once the user makes a choice, the label will be placed on the footer of every page. If a document already has classification labels, the user should get a button or a menu option to edit the labels. If he selects this option, he is asked to choose the label and that label will be applied across the footer of every page. One way for me to build this solution is to create macros. However, is there a better way where I need not build individual macros? Pranav ** To leave the list, click on the immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** program-l-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** program-l-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** program-l-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** program-l-request@xxxxxxxxxxxxx with the Subject:- faq