ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom sheet protection (https://www.excelbanter.com/excel-programming/290523-re-custom-sheet-protection.html)

Tom Ogilvy

Custom sheet protection
 
Select the cells where you want to allow entry and right click on them,
Format=Cells, choose protection and uncheck locked.

All other cells should be locked (default)

No do Tools=Protect=Worksheet.

That should do what you want.

--
Regards,
Tom Ogilvy

"matrix" wrote in message
...
I want users to be able to enter data into cells, but not delete or insert

rows or columns.

I can't seem to get sheet protection to work right. Which options do I

select, or is this not possible?




All times are GMT +1. The time now is 09:21 AM.

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