Paste as Values - Keeping cell format when copying from email to Excel

[teletar]

Hi,
I really need help with Excel 2007. I have a workbook with 9 sheets and I would like some help to create a VBA code that will force the user to paste value only in these sheets. the user can copy text from email, word or any other place but when they come to my sheet, I want them to just paste the value without changing the structure or format of my sheets.
Any thoughts? I looked all over the internet and was unable to find anything.
Thank you in advance.
-T

 

[seenfresh]

What about sheet protection?

http://spreadsheets.about.com/od/excel2007tips/qt/080528_protect.htm

 

[teletar]

Thank you.
Sheet protection does not help. my sheet is like a user form. the user will need to answer the form but sometimes the user copy and paste into the form and that is creating many issues - format problems, cells being protected and they should not..etc.
Thanks