greetings all, i would like to build a macro in Word and Excel which prompts the user, before printing, with a yes or no question: (for example) "would u like this sentence printed at the bottom?". If yes, the text (again this is an example): "this text should be at the bottom of your page!" should appear at the bottom of the document and it will print this document including the text. If no, then it will continue to print without it of course. is there any way of doing this? any help would be greatly appreciated

It can be done with VBA usng the before print declaration in the workbook. Example: Private Sub Workbook_BeforePrint(Cancel As Boolean) Msg = "ARE YOU READY TO PRINT??" ans = MsgBox(Msg, vbYesNo, "") If ans = vbNo Then Cancel = True End Sub

thanks much! that's a good start for me. i'm not much of a VB scripter but this is a good start