Hardware Man
New Member
- Joined
- Apr 10, 2013
- Messages
- 40
I'm developing a spreadsheet which has about 40 columns or so. Half of them are formulas that I want to protect, the other half are cells that the user needs to fill in and are to remain editable. The number of used rows will vary greatly, depending on the user.
The formulas are written in such a way as to always display a blank cell if the user did not enter his data where he's supposed to. This enabled me to copy down about 1000 rows, even though most users will only be using about a hundred rows at the most.
What I'd like to do is protect the cells that I don't want the user to mess with, while enabling him to delete an entire row if that data is no longer needed. I don't want him to be able to insert rows, just delete them.
Is this possible?
The formulas are written in such a way as to always display a blank cell if the user did not enter his data where he's supposed to. This enabled me to copy down about 1000 rows, even though most users will only be using about a hundred rows at the most.
What I'd like to do is protect the cells that I don't want the user to mess with, while enabling him to delete an entire row if that data is no longer needed. I don't want him to be able to insert rows, just delete them.
Is this possible?