Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent carrige return from being pasted
Hi,
I have a problem I can't solve. I have a list of comments written in a range in a shared workbook. Individual users open the book and edit the comments, before saving and closing. The problem I have is that some users copy their comments from word. Often they have used carriage returns to start a new line. This causes half of the comment to be pasted into the correct cell, and the rest to be pasted into the cell(s) below. Is there a way to prevent this from happening? Many thanks for any advice. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
How to prevent a formula from returning #REF! instead return 0 | Excel Discussion (Misc queries) | |||
How do I replace a carrige control(box) in excel using VB | Excel Programming | |||
carriage return that works when pasted into a text file (eg. Notep | Excel Discussion (Misc queries) | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) |