Hi all,

I have an excel sheet containing text that I require copying and then pasting into a 3rd party application (bit like notepad).

I need to use a button to copy the text so it cannot be edited or changed. I can copy single lines of text and remove the return charter from the end of the text using:

Please Login or Register  to view this content.

However, when it comes to a cell with paragraph spacing, the text gets pasted as a single line and not 3 single lines with a break between EG:

I want to paste this:

I need to use a button to copy the text.

It cannot be edited or changed.

I can copy single lines of text.

But I get this:

I need to use a button to copy the text.It cannot be edited or changed. I can copy single lines of text.

The final obstacle is that I require the cell to be editable and the macro/Active X control to copy the new edit. This is so no experience is required to get the button working again as it will be used across a team that does not use excel.

I can do the copy and paste if I select the text in the cell to clipboard and paste it manually so there must be a way.

Any help gratefully recived