Unprotect the multiple sheets and protect them again

[itisalikhan]

I have a workbook that contains 13 sheets. Sheet5, Sheet 7, Sheet 8, Sheet 9, Sheet 11 are protected by vb codes and the remaining sheets are unprotected. I want to do following things with the help of a macro.
i) I want to unprotect the protected sheets (i.e Sheet5, Sheet 7, Sheet 8, Sheet 9, Sheet 11)
ii) Then want to write my vb codes ( I already have) that’ll perform copy paste function among above mentioned sheets
iii) And then Protect the above sheets again.
iv) I want to run this macro when I click on Cell A10 of Sheet1.
Any help will be highly appreciated.

[p24leclerc]

here is a macro that may help you. It has to be in your Sheet1 code.

Please Login or Register  to view this content.

you can see the attached file as example.

[itisalikhan]

Thanks a lot for your kind guidance. Actually, i don't want to write the code as "Private Sub". i want to write it in the module. I want to do somthing like given below:-

Please Login or Register  to view this content.

Can you please
i) shorten the highlighted codes for me
ii) triger the macro when i click on cell A10 of Sheet 1

[lmp]

Hello,

Please consult the forum rules (linked to above in the navigation bar)

Please change your thread title to describe your issue and please post code in code tags.

[itisalikhan]

Hi there! LMP
Please, excuse my ignorance. Needful has been done. I'll be carefull in future.

[p24leclerc]

I don't see how to shorten your code to unprotect sheets and I don't even think it is doable.
If also think the only way to know if a cell is changed or selected is by EVENTS PROCEDURES which out to be specific in one sheet as I did.
If you find another way, I'd like to see it.
Regards

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...ll-sheets.html


Thread Closed.