Locking specific cells/rows through a button

**Simon Lloyd** · 04-07-2008, 11:20 AM

Firstly if you read my post properly you will notice i said

Originally Posted by Simon Lloyd

in doing so ALL locked cells will be protected so you have to make sure you clear those first

in other words unlock all the cells first before using the code to lock/unlock cells.

Secondly it would be far more helpful if you could create a dummy workbook with 2 sheets in one with how it is before the action and one with it after, zip it and attach it, that way we can see your structure and try to workout a solution accordingly!

**Edward HS** · 04-08-2008, 08:37 AM

Thanks for your reply! Sorry for the confusion.

I attached my file. In sheet "boekhouding" I want every cell in column H to contain a button that locks that specific row. So I can't accidently change the dropdownmenu for that row.

Is that possible?

I also have some sort of strange problem in worksheet "Rekeningen", Range D1-D5 is named "Grootboek" were it should be named uitgaven. I can't change the name, but it doesn't seem to matter in worksheet rekeningen (the drop down menu for uitgaven works normally), what is wrong here?

Please help me!

Thanks,
Regards,

Edward