Protect Column in Worksheet VBA

**newtons003** · 08-04-2014, 10:45 AM

Hello -

I've been given the task of modifying an existing VBA program and I'm trying to find out if there is a way to protect specific columns of a worksheet in VBA script. I've attempted to use the built-in 'Allow Users to Edit Ranges' permissions within Excel - which works great for my test program, however, when I try to implement it in the 'live' worksheet - a User without permission is still able to edit a given field.

So, I turned to VBA. Of all the research that I've done, I haven't found a scenario that is similar to what needs to be accomplished.

Is it even possible to create USER Permissions for only specific columns of a worksheet? (i.e. John can only edit column X - everything else would require a password). If so, this is a little out of my element and I'm not sure where to begin.

Any guidance is appreciated.

**ChemistB** · 08-04-2014, 10:59 AM

I don't know why Restricted Ranges wouldn't work for you. Are your "Live fields" locked and the spreadsheet protected?

**newtons003** · 08-04-2014, 11:59 AM

They are. I've tried a few times to make sure I didn't miss anything. I'm really at a loss.

**ChemistB** · 08-04-2014, 12:08 PM

Can you reproduce this problem in a sample workbook and attach it? (Go Advanced>Manage Attachments)
Here is a simple workbook where anyone can enter into column A but a password is required for Col B.

Password for B is test1 There is no password on the spreadsheet.