Hi guyz,
This is my first post on this forum and I THINK I have a tricky one lined up for you guyz...
SCENARIO:
1. I need to keep my worksheet protected
2. I've customized the rightclick menu that allows attaching of images
3. These images are stored in a separate worksheet, which remains hidden and becomes visible only when the user wishes to view a particular image
4. As soon as in image is attached, a comment is inserted in the relevant cell, which reads "Image Attached". This is done to enhance the usability factor
PROBLEM:
If I copy a cell, which has an image attached along with it (and the comment) and paste it onto a different cell, the comment is also pasted in the target cell, which should not happen (as a user might not have attached any image to that cell and if there is already an image attached, then the comment would already be there) and vice-versa. I want only the values to be pasted.
How can I acheive this??? Pls helllllp...
Many :thanx:
Rana