R
Roger on Excel
I would like to protect / deprotect multiple sheets with a single password in
a single action
At present i have to protect each sheet individually, each with the same
password which is tedious, especially as i have to do each sheet each time i
protect or deprotect it.
My 10 sheets are named : St1, St2, St3.........up to St10
Ideally i would like a form to pop up when i push a button which allows me
to either protect or deprotect these 10 sheets with my password in a single
action.
Can anyone help?
Regards,
Roger
a single action
At present i have to protect each sheet individually, each with the same
password which is tedious, especially as i have to do each sheet each time i
protect or deprotect it.
My 10 sheets are named : St1, St2, St3.........up to St10
Ideally i would like a form to pop up when i push a button which allows me
to either protect or deprotect these 10 sheets with my password in a single
action.
Can anyone help?
Regards,
Roger