Update sheet after changed Interior.ColorIndex
Hi,
I have written a little UDF to check Interior.ColorIndex of cell and
return the name of the color.
Purpose is to allow the sales people, who like to indicate sales
progress on their leads with colors, to sort/filter on color to get an
overview.
Problem is that the sheet doesn't update after changed color, need to
go into cell with the function and Enter. F9 doesn't help.
Tried Application.Calculate(Full) but no.
Any ideas?
/Fredrik
|