Allow Users to Edit Ranges.

Hi everyone,
I want to allow users to edit some ranges after protecting and sharing the work book. In the sample file which i have attached whatever the cell highlighted background with light violet color should be allowed for the users to edit and only some specific people in my work group.

In this file i have just given 2 ranges (Bay 1 & 2) where as in my original file i have around 11 ranges (Bay 1 to 11) each with 50 rows.

The pre defined option for this feature is having some limitation which i couldnt utilize it in this sheet.

Someone please help me....

Hi,

Format the cells you want to be able to change by unticking the 'locked' option in the Format protection tab before sharing and protecting the workbook.

Hi Richard
thanks for the scoop, but the issue is as i mentioned earlier the work book will be shared and if wanted to edit that particular range i cannot do that i need to remove sharing if i need to modify something, so that i am searching for VBA support.

Please suggest if there is any other soultion......

Shared workbooks are doomed! Shared workbooks with VBA ... doomed, just quicker. Don't envy you your task. It's doomed.

I generally quote Marcol from this forum: There are two types of shared workbooks, those that are corrupted, and those that soon will be!

http://www.excelforum.com/excel-gene...ple-users.html


Regards, TMS

Originally Posted by muralidaran

Hi Richard
thanks for the scoop, but the issue is as i mentioned earlier the work book will be shared and if wanted to edit that particular range i cannot do that i need to remove sharing if i need to modify something, so that i am searching for VBA support.

Please suggest if there is any other soultion......

Hi,

Sadly there isn't. If you want to edit a cell then you will have to temporarily remove sharing. I know of no other way. And I echo the other comments here about shared workbooks. It's a poorly implemented feature and they are a usually a real pain and an admin burden to manage subsequently.

Are your users wanting to update the same cells or do they all have their own dedicated ranges or sheets? If the latter then the best option is to use let all users have their own version of the workbook and use a Master workbook, controlled by VBA code to grab the data from the individual workbooks.

Actually the users of this sheet have their own ranges, they will enter any data in other ranges. Thanks for the suggestion about the use of master book but these datas are helpful for each other at the time of editing the data. e.g. when i modifiy some plan in Bay-1 the others users will be noteified about the valaue change using the SUM formula which is instant. more over these kind of editing will be done only once in a month for the production plan.

Hi,

If I understand your problem it still shouldn't be a problem. The process could work both ways. Every month update the individual workbooks (with a macro) with any changes, and then grab the data back again as described before.

Regards