here is a workbook demo:
http://www.datafilehost.com/download-553fafeb.html
Ok. Let me explain.
I have an Excel worksheet with a Source Cell and a Target Cell.
Via GDI API functions, I draw a temporary gradient fill over the source cell which happens to be cell "D6".
then, I make a transparent copy of the temp gradient fill drawn over the source cell and place the copy (ie the transparent gradient fill) over the target cell which happens to be cell "D9".
Ultimatly, my goal is to have only the target cell with its transparent gradient and get rid of the source gradient.
I am using the InValidateRect to erase the temp fill located over the source cell by passing to the function the application hwnd and the exact Rect value of the source cell (measured in screen pixels) .This is according to the API tutorial. YET ,when called, InValidateRect either doesn't do anything at all or redraw the entire screen instead of redrawing the source cell rect only as expected.
Any help would be much appreciated.
Jaafar.