I've developed a nifty VB driven expense report that allows my project
managers to enter expenses in multiple currencies and have them converted to
a common currency for expense payment.

To do this, the PM selects the currency from a drop down box. When this is
done, I use a mask and fill the column with the appropriate currency symbols
and load the conversion rate into a special cell.

The problem: If all entries into the expense report are entered by hand,
all is well. However, I have one PM who uses an unformatted spreadsheet to
compute his expenses... say for food and beverage... then he copies the total
from the spreadsheet into the expense report.

When this happens, it not only copies the amount, it also copies the
formatting and the cell in the expense report no longer contains the mask for
the formatting of the currency... the shading is also smacked.

Is there a way to protect my expense report so that he can copy the totals
from his scratch worksheet without altering the format of the cell?

Thank you.