Hi,
Thanx for the reply. I pasted that VBA code, but I'm still able to change data in A2 by/when entering it in A1, as if nothing were changed...??? (Macro security is wide open, too, in Excel 2007)... Ummm, again, I'm trying to limit the concatenation into A2 (from A1) to the FIRST, or to just ONE, "concatenatory instance", and to have it frozen there for eternity.
Tanx again,
G
All the code does is catenate A1 to the end of A2 when the workbook opens. If you change A2 manually, umm, well, A2 changes. What else would you expect?
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
gandolff 
Register To Reply
Bookmarks