No, no - maybe you do not understand me.
I attach the file and there is your macro.
Try it:
First - when you open the workbook - the selected sheets will be locked and rows will be hidden.
2nd - press the button to unlock all selected worksheets (you can see them later in the macro), and see the result - no unlocks them and does not show the hidden rows.
3rd - if I get this "= pw" and put "InputBox (" Please write your password! ")" For each worksheet selected (recorded) in the macro begins to climb my form and wishes of each worksheet entering a password (this well if i have different passwords).
but in my case for all selected worksheets I have only one single password - ie the same for all sheets - and I wish once you show the form, I write the password only once to unlock all sheets and show rows.
Please try the file.
I hope now to be able to understand it.
But if there is something - please ask boldly.
Thanks
Perhaps the quickest option that comes to mind as an explanation:
pressing the button
displayed form
write password (same for sheets -> "kosta", after that i will change passwor, this is for the sample file)
pressing OK
unlocks the sheets (only those who have found its way into the macro., not all)
shows rows
Reply With Quote