PDA

View Full Version : ctrl c and ctrl v breaks a merge cell



eg_ckhad
07-27-2008, 07:27 PM
Hi,

I am creating a input form to let users to input something and generate a file.

I merged few cells that let users to input address.

But I find one loophole that users can key ctrl c and then ctrl v to break the
merge cell.

I have set the name of the merged cell to vAddress such that I get the value
by this name when generating a file.

Any one knows how to solve this problem . Thanks in advance.


eg_ckhad

Simon Lloyd
07-27-2008, 09:42 PM
You may well be new here (not at other forums!) but the rules on cross posting are the same as in every forum!

cross posted here (http://www.excelforum.com/showthread.php?p=1948829&posted=1#post1948829), the thread at the linked location has been locked so you can continue here with your question.