In Excel protect or unprotect multiple tabs with one password at .

T

Tony-EPIC

I create budget templates with multiple tabs. They include complex formulas
that move information from one tab to another and from one file to another.
I unprotect areas where managers can enter their budget numbers and protect
all my formulas. For easy of remembering, I use the same password on
multiple tabs in each file. Currently I have to click on each tab and
protect or unprotect the dtab to make changes int he protected areas. It
would speed up the process if I could select multiple tabs and protect or
unprotect all the selected tabs with the same time with the same password all
at one time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top