Unable to lock cells

[BMD4]

Hi,

I am trying to lock cells in excel when I run macro, but id doesn't work.

Below is the code.

Public Sub submit_button()
Range("B4:B8").Locked = True
End Sub

B4:B8 are the cells which i am trying to lock. Please let me if I am missing anything here.

Thanks in advance

[kev_]

Sheet must be unprotected

Please Login or Register  to view this content.

[BMD4]

Thanks Kev. That works.

I need cells to be locked based on value of another cell which is a named range 'choice'.

If choice = NWC. cells should be locked else locked = False.

Can we have condition on password protected code

[kev_]

Please Login or Register  to view this content.

[BMD4]

Hi Kev,

Thanks for the reply.

I am trying to understand the logic of

.Range("B4:B8").Locked = ([choice] = "NWC")

I am looking for Locked to be true is if Choice is "NWC". If Choice is other than NWC, Locked should be 'False'.

The logic seems to be assigning Locked value = ([choice] = "NWC")

Please let me know if I am understanding it right

[kev_]

The code is written to achieve what you require
The locked status of B4:B8 is set to the result of what is inside the parenthesis
- inside the parenthesis equates to true or false

[beuermant]

I have a similar question, but I want to lock certain cells (formulas, column titles, etc) from being edited, but need the input cells to be editable. Also, I need to easily be able to delete all the cells that have input data without deleting the formulas or content in the protected cells.
So, using a protected sheet doesn't quite work. It seems to be a quicker way of selecting cells and locking them under protections and then protecting the worksheet.

Any options to accomplish what I'm trying for?
Thanks!

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread