98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection settings
Protection settings
Resolved · Urgent Priority · Version 2007
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?
Fri 24 Sep 2010, 15:40Trainer Newson said...
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
Fri 24 Sep 2010, 15:41Trainer Newson said...
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.
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. |
Excel tip:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |
