How to print all items in drop down list in excel2007?

[kptjagan112]

Hi,

I want to print all options in drop down list at a time is there any macro for print all options ? i m using excel 2007.

here i am attaching the document. please find the attachment.

Thanks & Regards,

Jagan.Pay sheet.xlsm