I have a range of cells that are locked but where cell formatting is enabled. Row and column formatting is disabled. And I want to programatically prevent the user from pasting a merged range (either rows, columns or both) into the protected range.
I'm thinking I would need some king of Worksheet_BeforePaste code in the worksheet. Either that or some means of evaluating the content of the buffer.
Thanks in advance.
Kevin
Bookmarks