I guess asking the Paster to use Paste Special - Values is out, so
perhaps a Worksheet change event to re-setup the formats where the
specified range is involved would be the go.

Hope this helps

--

Strong Eagle Wrote:
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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537523