View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Protect worksheet

ActiveSheet.EnableSelection = xlUnlockedCells

--

Vasant

"madcat " wrote in message
...
How do i protect a worksheet from being copied / duplicate and user can
only select the cells that are not protected?


---
Message posted from http://www.ExcelForum.com/