VBA code that has repeated numbers

[nassark]

Hi, i need help with this part of code

Please Login or Register  to view this content.

As you can see im protecting the sheet with the password 505050 and i have it repeated 3 times, is there a way to change the number with some shortcut or something so i change that password only once? I'll teach someone how to change it so he can put his own password and I just want that he change it in only one part not 3.

thanks in advance

[nigelog]

See if this works

Please Login or Register  to view this content.

[nassark]

It worked my friend!! but I have a question. Can that code applied to all sheets in the workbook? all are gonna be the same but with different names. Can it be applied so if I change the ps value it changes in all sheets?

[ImranBhatti]

You may use nigelog's code in the bellow event of the workbook

Please Login or Register  to view this content.

and replace sheet name used in the code to sh like

Please Login or Register  to view this content.

would be

Please Login or Register  to view this content.

assuming all sheets have the same structure and password

[nassark]

Totally work!! Thanks for this great help both of you!! My problem have been solved!

[nigelog]

No problem,

can you mark thread as solved nassark

and thanks for the rep

[ImranBhatti]

Thanks for the feedback and rep+