Allow users to edit ranges - different ranges for different users.

[staljunk]

I am working in Excel 2010 and have an Excel file that I am using combo boxes and have a VBA code written to autofill the combo box. I also entered three user groups to give access to specific columns for editing. I have setup three groups in the “Allow Users to Edit Ranges” section. One group/person can only edit column R, another group can only edit columns S & V, the third (one person) I list the entire worksheet. I also have the workbook as a shared document.

I first created the workbook, then emailed it to the person who has access to save the document in a particular file on the company shared drive. I do not currently have access to edit files within that folder.

But, this is not working. I tested the above with one of the people I have assigned to range 2 and she was able to edit any field in the worksheet and was never asked to enter a password.

I had originally unlocked columns R, S & V, thinking I would need to do the same process as when I do a general protect of the workbook (without assigning user ranges).

Any help would be appreciated.

[mikeTRON]

Are you using VBA to lock and unlock ranges depending on usernames?

[mehmetcik]

Hi

Are the users using Userforms?

How about this as a solution:-

Remove all formulas from the key Document(s).

The user must run a macro to populate the Document(s) with its formulae.
The macro checks for passwords

Protect the key Formula being viewed or modified by making the cells unselectable

Protect the document from being saved with the formulas exposed by using a workbook before save macro.

[staljunk]

the VBA is for auto-fill combo boxes.

[staljunk]

I do not have any userforms in this document. I am not trying to protect formulas, but am trying to only allow one particular department access to add information to one column and allow another department access to edit two different columns, then a third person to have access to the entire worksheet. I don't want one department to be able to edit another departments data.