A
Al Mackay
Is it possible to intercept the ALT-ENTER function?
I need to be able to prevent people from doing ALT-ENTER within cells
as I extract the information into text files for reporting purposes
and as a result the data is formatted incorrect (as it see's each new
entry within a cell as a new line in the text file).
Is it either possible to not allow this, or alternatively to be able
to detect where it's been done and replace with a comma and a space?
That way I could run this macro which corrects the formatting before
the text file is created?
Appreciate your help on this. Many Thanks, Al Mackay (
(e-mail address removed) )
I need to be able to prevent people from doing ALT-ENTER within cells
as I extract the information into text files for reporting purposes
and as a result the data is formatted incorrect (as it see's each new
entry within a cell as a new line in the text file).
Is it either possible to not allow this, or alternatively to be able
to detect where it's been done and replace with a comma and a space?
That way I could run this macro which corrects the formatting before
the text file is created?
Appreciate your help on this. Many Thanks, Al Mackay (
(e-mail address removed) )