How to Control Users to edit

dolphine4u · #1 07-22-2016, 02:28 AM

Hi Experts,

Need your help pls

I have an excel with below info in A, B, C & D columns

A B C D
Sulphonator InvoiceNumber Ext.Qty Req.Qty
Anil 12345 100
Kumar 34567 78
Sam 93748 56
Anil 823423 12
Sam 8918 786

My requirement is that i have placed this excel on shared drive and given access to users mentioned in column A.
If Anil opens the workbook he should be only allowed to edit column D where his name is in column A and reset cells should be locked / should not allow to be edited.
Ex: Anil name is seen in Sulphonator column in line 1 & 4 so he should only be able to enter Req.Qty in row 1 & 4.

TIA

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Check Box Content Control when checked users are presented with an option	cryder	Word	0	01-07-2016 05:11 AM
Edit table in content control	denise do rocio maciel	Word VBA	2	01-03-2016 11:59 PM
Clicking the selected Content Control checkbox returns wrong control in vba event	DougsGraphics	Word VBA	2	06-24-2015 07:31 AM
Word 2003 Document Opens In control toolbox Edit Mode	rangasamy007	Word	1	09-16-2011 04:12 AM
Set text in edit control on inspector window indicating time Outlook 2007	saniltalathi	Outlook	0	02-20-2009 08:43 AM