View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Protecting worksheet

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