Hi.
I want to block only the cells "B1, C1, D1" if cell "A1" is different from "RECAP"
Please Login or Register to view this content.
Hi.
I want to block only the cells "B1, C1, D1" if cell "A1" is different from "RECAP"
Please Login or Register to view this content.
Last edited by marreco; 10-20-2012 at 05:33 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Do you mean to say the other cells are also getting blocked? By default, all the cells are locked. When you protect the worksheet, everything will become uneditable.
Hi.
There is no way to block only just "B1, C1, D1"?
Tthank you!!
Unlock all the cells in your worksheet. When this code runs, it will block only B1, C1, and D1.
Hi...
I want to block only the cells "B1, C1, D1" if cell "A1" is different from "RECAP"
Hi
Any idea?
Thank you!!
Ya unlock all your cells.
1. Unprotect your sheet
2. Select all cells --> goto format cells
3. Under protection tab --> uncheck "Locked"
4. Protect your sheet again
When your code runs, if cell A1 is not recap, it will lock only b1,c1 and d1. And you can edit the other cells.
hI.
this is not what I need, should be done automatically.
if "A1" = "RECAP" then only cells "B1, C1, D1" poderam be edited (the user will enter values in these cells).
if "A1" <> "RECAP" then only cells "B1, C1, D1" could not be edited (NOT the user will enter values in these cells).
hI.
this is not what I need, should be done automatically.
if "A1" = "RECAP" then only cells "B1, C1, D1" poderam be edited (the user will enter values in these cells).
if "A1" <> "RECAP" then only cells "B1, C1, D1" could not be edited (NOT the user will enter values in these cells).
Hi.
Any idea?
Thnak you!!!
Hello marecco,
Try the attached WorkBook. No Protecting sheet, and Cells B1 to D1 are Blocked, if Cell A does not equal "Recap".
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
If I understood correctly your request, try this:Please Login or Register to view this content.
Last edited by rollis13; 10-20-2012 at 04:39 PM.
hi rollis13
I answered your code so perfect!
thank you very much!!!
Glad being of some help
There could be an issue with the ".UsedRange." if you need to use cells out of the previously used range.
Hello marecco,
You are welcome.
Thank you for the nice Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks