Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection settings
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Protection settings
Resolved · Urgent Priority · Version 2007
Reply Thu 23 Sep 2010, 17:19Delegate Liz said...
Liz has attended:
SharePoint course
Protection settings
Hello
I am trying to set up a spreadsheet in which one range of rows is editable by all users: they should be able to insert rows as well as enter data.
There is another range of rows which I wish to lock up so that the cells only receive new data from another worksheet which has a paste link relationship. This second range of rows not permit row insertion.
If I protect the sheet it seems the INSERTION tool is entirely disabled, despite the fact that I have carefully defined which cell ranges are locked and which unlocked.
Also: how can we disable CELL insertion whilst retaining ROW insertion please?
For upcoming training course dates see: Pricing & availability
RE: protection settings
Hi Liz
You cannot allow users to insert rows on certain cell ranges
checking this box will allow users to insert rows whether the cells are locked or unlocked.
What you want to achieve I don't think can be done through the protection dialog.
What you want to achieve can only be done by programming Excel using its own inbuilt programming language. We offer consultancy on this if you are interested?
I will refer this issue to our consultancy desk. They may drop you a line
Many thanks
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Fri 1 Oct 2010: Automatically marked as resolved.
|