Workbook Security Help

[jsambrook]

I'm trying to use a macro to copy a 2 rows that I want hidden. The macro unhides these rows, copies them and then hides them again. It worked ok until I tried to protect the worksheet. I've tried unlocking these rows, and and the surrounding rows. But it always crashes as the macro is trying to unhide the rows. Anyone know a work around?
thanks

 

[jsambrook]

Can I get the user to input the password and put it in as the password?