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