Protection settings

Resolved · Urgent Priority · Version 2007

Thu 23 Sep 2010, 17:19 Delegate 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:40 Trainer 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:41 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

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.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips