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

 

[VoG]

Maybe like this

ActiveSheet.Unprotect Password:="abc"
'
'your code
'
ActiveSheet.Protect Password:="abc"

 

[Jonmo1]

Also, you don't need to unhide a row in order to copy it...

 

[jsambrook]

Thanks, will give it a go.

Only reason I unhid it was because when it pasted the cells elsewhere, they were also hidden!

thanks for your help
Janni

 

[Jonmo1]

Thanks, will give it a go.

Only reason I unhid it was because when it pasted the cells elsewhere, they were also hidden!

thanks for your help
Janni

You can unhide it at the paste destination.

You have to unhide it one way or the other right?
Might as well do it at the destination to avoid having to unprotect/reprotect the source sheet.

 

[jsambrook]

Does that mean that anyone opening the macro will be able to see the password?

 

[jsambrook]

I thought that it would be easier to hide the one I was copying as it will always be in the same place. I'm not too fluent at writing script and wasnt sure how to locate the new row I had pasted.

 

[GTO]

Just curious... When you say 'copy,' are you looking just to take the values in the cells somewhere else, or do you need the cells' formatting, forumulas, etc to go along for the trip?

 

[jsambrook]

Two rows are copied that have formulas linking to one of the cells in that row, and also some other cells in the spreadsheet. It also has an input box that changes one cell in these rows that gives the rows a new meaning.

 

[jsambrook]

I have a slight issue with a hyperlink and my secured cells. I want the hyperlink to be clicked but not to edit the contents of the cell. For some reason it works on one tab and not on the other. I cant see any difference in the formatting or anything else. I initially wanted it set up so that you couldn't even click on locked cells, but the hyperlink seems to work on one sheet with click on locked cells. However, this doesn't work for all tabs! removing protection, the hyperlink does work!