Protecting worksheet
 

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

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