ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   restriction for delete or change in cell (https://www.excelbanter.com/excel-programming/445391-restriction-delete-change-cell.html)

kalpesh

restriction for delete or change in cell
 
Hello,

in worksheet 1 contain very important data i like make a macro for user do not
delte & change the data in any cell in sheet1 without permission

Don Guillett[_2_]

restriction for delete or change in cell
 
On Feb 16, 12:55*am, kalpesh
wrote:
Hello,

*in worksheet 1 contain very important data i like make a macro for user do not
*delte & change the data in any cell in *sheet1 without permission


By default, cells are protected if the sheet is protected. So,
formatprotectionUNcheck cells that you do NOT want to
protectprotect the sheet


All times are GMT +1. The time now is 10:06 AM.

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