Lock cells with text only

[hcyeap]

Hi, I need to lock the cells in my sheets with text only and allowing the blanks one to be edited.

I found this following code. However, it locks all the blank cells as well.

Can anyone advise?

Also, I need another similar macro to lock cells with text only across multiple sheets at one shot. Appreciate if anyone is willing to help.

Thank you!

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

[hcyeap]

Hi stnkynts,

Thank you for your reply.

I tried and this code works perfectly. However, there is a catch. I have to select all the cells first, then format cells >> protection >> uncheck locked.
It will only work after doing these.

Is it possible to add these steps into the code?

Also, if i would like run this code across multiple sheets, would be adding a select all sheets code works?

Thank you very much!

[fredlo2010]

Hello,

The default for the cells is locked. This code will go through every single sheet and lock the specified range. See if this code helps you out:

Please Login or Register  to view this content.

and a less heavily commented version:

Please Login or Register  to view this content.

Thanks

[hcyeap]

My apologies.

I thought asking a general question can solve my problem.

The code was working well when I test it. However, if I tested them on my actual report, it will show error message.

Attached is my actual work. I have 30 sheets but I just included 2 only.

Appreciate any assistance.

Thank you.

[stnkynts]

fredlo2010 code works just fine on the sample you provided. You're doing something wrong.

Note: You can edit fredlo2010 code so that it automatically unprotects the sheets without having to enter a password just by editing the .Unprotect line to include a password in the same manner as the .Protect line

[fredlo2010]

fredlo2010 code works just fine on the sample you provided. You're doing something wrong.
Note: You can edit fredlo2010 code so that it automatically unprotects the sheets without having to enter a password

Thanks for the catch stnkynts

This is how the final code would look:

Please Login or Register  to view this content.

Thanks

[hcyeap]

Thank you very much stnkynts and fredlo2010.

I think it was due to something wrong with my file. I resave it and it works flawlessly now.

Thank you!

Regards,
HC