Maybe you can try Jan Karel Pieterse' CatchPaste technique:
http://www.jkp-ads.com/Articles/CatchPaste.asp
John in Wembley wrote:
Hi team
WS.Protect UserInterfaceOnly:=True, AllowFormattingCells:=False
still allows a user to cut and paste inside unprotected cells.
I wish to stop this as they cut the borders and fill colour as well.
Can this be protected?
Thanks
john
--
Dave Peterson