JamieLee2k
New Member
- Joined
- May 9, 2004
- Messages
- 38
I have this protected worksheet which is stopping people from clicking on the cells they don't need to access, hense protecting my work from being used by others in my workplace, but there is an issue I have faced and I don't know how to get around it.
What I want people to be able to do is insert a Row, but since the worksheet is protected they are unable to do this, If I tick "Select Locked Cells" & "Insert Rows" then yes people can insert rows but it means they can click on the cells I don't want them to click on, but can't edit them. I also have "Select Unlocked Cells" ticked so they can put in data that is required.
In a short I want to be able to:
I really hope you all understood that, So what are my options?
Thanks
JamieLee2k
What I want people to be able to do is insert a Row, but since the worksheet is protected they are unable to do this, If I tick "Select Locked Cells" & "Insert Rows" then yes people can insert rows but it means they can click on the cells I don't want them to click on, but can't edit them. I also have "Select Unlocked Cells" ticked so they can put in data that is required.
In a short I want to be able to:
- Lock Cells so others can't click on the ones they will never use
- Allow Users to Insert Rows
- Protect worksheet
I really hope you all understood that, So what are my options?
Thanks
JamieLee2k