Change colour when value of a cell is changed

[Doja]

Hi there, I want to send to our sales reps their list of contact persons & their contact data (email, phone, ....). I would like that each single cell in which they changed something is given a certain colour. That way I can easily identify what cells have been modified. Thnx, Doja

[Eastw00d]

you could place an ActiveX-CommandButton to toggle these events ON/OFF in the worksheet, and in the code of this worksheet the following:

Please Login or Register  to view this content.

Cheers
Erwin