me.calculate prevents copy and paste?

HI,
I have a worksheet that sums up cells based on if they have been shaded any color.
I managed to write a function that acheives this, however I did have to hit f9 every time any of the cells were changed to recalculate the totals.

I got around this by putting me.calculate in the change event of the sheet.
The issue I have no is that when you select copy, then move to another cell it forces the calculation and you loose the data you copied, which just shows as paste being greyed out.

How do I update the calculatons when a change is made, but still have the ability for users to copy and paste within the worksheets.

Are you sure you have put me.calculate in the "Worksheet_Change" event and NOT the "Worksheet_SelectionChange" ?

Isn't this a dupe posting of http://www.excelforum.com/excel-prog...d-pasting.html

You were right, i had it in worksheet selection change. however, when i changed it to worksheet_change it doesnt pick up the event of cells being colored in. I still have to get my users to hit f9 everytime they make a change.

Any thoughts?

Yes it was a duplicate, i apologize. No one replied to the first one and I thought perhaps I could have worded it better. I didnt mean to post twice, despite being desperate to get this fixed.

HI Tod:
Are you really sure you want to do this by color ? Are the colors going to be the same between 2003, 2007 and 2010 ? What if a person uses a slightly different shade ? Also the other "data" tools are not going to work with colors ... i.e. you cant sort by it , filter by it , pivot by it , or use the formulas by color ... I think you are going to keep running into issues with colors.

HI, I know it is best not to go with color shading however, because of the current process we have here I have been madated to make it work. It isnt so bad, because If they cell is shaded any color at all it doesnt need to be counted, i am actually just looking for cells without bacground color, or white cells.
The code works perfectly ( I can cut and paste it in here if that helps), and when i had the me.calculate function everything worked fine. Until i bumped into this copy and paste issue.
It must be common for people to want to make the sheet calculate and then realize they loose copy and paste?
Thanks for your patience.
Todd