E
Eduardo
Hi all, and thank you in advance
I have in total 23 sheets in a worksheet, 12 of them protected with a
password and the other 11 with a different one.
The idea is that two different areas will share the spreadsheet, I have
already created the macro that will ask, for each tab opened for the password
(if it's wrong it will stay in the "Menu" tab. What I need to do is when both
areas has finished entering all the information, is to open all the sheets in
order to run the macro that summarize all the sheets.
If somebody can give me an example with two sheets I will be able to add all
the others sheets. Thank you
I have in total 23 sheets in a worksheet, 12 of them protected with a
password and the other 11 with a different one.
The idea is that two different areas will share the spreadsheet, I have
already created the macro that will ask, for each tab opened for the password
(if it's wrong it will stay in the "Menu" tab. What I need to do is when both
areas has finished entering all the information, is to open all the sheets in
order to run the macro that summarize all the sheets.
If somebody can give me an example with two sheets I will be able to add all
the others sheets. Thank you