View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John in Wembley John in Wembley is offline
external usenet poster
 
Posts: 26
Default 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