ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protect worksheet (https://www.excelbanter.com/excel-programming/308344-protect-worksheet.html)

madcat[_9_]

Protect worksheet
 
How do i protect a worksheet from being copied / duplicate and user ca
only select the cells that are not protected

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


Vasant Nanavati

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/





All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com