Ask for cell A1 value before printing out worksheet.......
 

i hope someone can help me with the above......i've tried using before
print.....if it could also ask me for a footer before printing as well
that would be useful,

thanks alot

andrea