That suggests you tried to run the macro manually, instead of firing it from a formfield in the table.

Without seeing your document - and ideally a sample workbook as well - it's difficult to give tailored advice. You can attach a document to a post with some representative data (delete anything sensitive) via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]