Protecting row.count - 1 when inserting from userform

**timtim89** · 02-08-2012, 10:13 AM

Hi,

I'm inserting content from a userform into an excel sheet. The sheet is locked, but I want to be able to change the last row that has been inserted. It's probably the Range that I'm not defining right, but hopefully someone can help me out. Thanks in advance for your help and effort.

Please Login or Register  to view this content.

**Mordred** · 02-08-2012, 10:40 AM

Hi timtim89, your worksheet is password protected.

**mohd9876** · 02-08-2012, 10:59 AM

the problem is probably in this line:

Please Login or Register  to view this content.

it should be like this

Please Login or Register  to view this content.

**snb** · 02-08-2012, 11:14 AM

This suffices:

Please Login or Register  to view this content.

**timtim89** · 02-08-2012, 12:17 PM

Thanks for all your suggestions. Unfortunately none of them solved the problem.

mordred: the password is written in J10. My bad that I didn't highlight it somehow.

mohd9876: I get a run-time error '1004' on the line, unfortunately.

snb: When I exit the userform the whole sheet is still protected (including the last line).

If someone can solve it by changing my initial code it would be preferable as I am familiar with that one. I know it's probably a clumsy one, though

thanks again for looking into my problem.

**snb** · 02-08-2012, 12:56 PM

Please Login or Register  to view this content.

**timtim89** · 02-09-2012, 06:01 AM

snb, thanks for your effort. On the last code I get a run-time error 438 saying that object doesn't support this property or method, while highlighting the "Rows()..Resize()..Protect.." line. This was after adding an "End With" to your code btw. So the problem is still there..