Protecting Columns

[HunterN]

I want to allow the user to modify the worksheet, but NOT allow them to modify the
Project Number (which is always in the first column).
Can this be done? If so, how can I write this in VB code?

Thanks, Nancy

 

[russell_piper]

You mean that you want them to be able to edit the rest of the sheet but not edit anything which is in Column A ?

 

[Corticus]

no need for code,

just password protect the first column.
First unlock cells that will receive data,
then,
Go tools, protection, protect sheet.
Remember cells are set to locked by default, so you have to unlock the cells that will receive data before you protect the sheet.

HTH,
Corticus

 

[HunterN]

Exactly. I don't want them to be able to change the Project Number if they choose the Modify button. I still want the first column visible. They just can't change it.
There is three other columns that can be change that go with the Project Number.

Nancy

 

[russell_piper]

What you need to is change the protection of the cells so that they are unlocked apart from column A. You then go tools, protection, protect sheet and the user will not be able to edit any data which is in column A.

Hope this helps

 

[HunterN]

I just can't get it working!

This is the code:

Worksheets("MCAR Project List").Unprotect
Range("A3").Select
Range(ActiveCell, ActiveCell.End (xlDown)).Select

Selection.Locked = True
Selection.FormulaHidden = True

bottomRw = Application.CountA (ActiveSheet.Range("A:A"))

ActiveSheet.Range(Cells(2, 2), Cells(bottomRw, 4)).Select

Selection.Locked = False
Selection.FormulaHidden = False
Range("A1:D1").Select
ActiveSheet.Protect Contents:=True, Scenarios:=True

It still won't allow me to update just the three columns. Everything is protected.

Any suggestions? Nancy

 

[russell_piper]

Nancy, there is no point using code for this if you refer to the my earlier post you can do it without.

 

[HunterN]

I understand that there is no need to use code to do this, but I am within a system module that does not allow the user access to the taskbar or formula bar until they press the 'MODIFY' button. Which means that it has to be written in VB code. I have tasted it on a separate spreadsheet and it works but I can't get it to work with my VB code as above.