K
KLLuoma
I created an internal form for my company that is a 15 tab workbook.
However, each sheet has to be locked seperately which is tedious when it
comes to unlocking. Leaving the form completely unlocked is out of the
question. We would like to see a Protect ALL Sheets Same function so that
you can set the cells to locked or unlocked, and then protect either ALL of
the sheets in a workbook with exactly the same protection, or even better,
you can choose which sheets you want to fall under the protection. AND, you
can still protect the other, unprotected sheets individually. (E.G. Sheet 1,
can select unlocked cells only, Sheet 2-14, can select unlocked cells, insert
or delete rows, format colums, sort and filter.)
The Protect ALL Sheets Selected would only require entering the password
once lock and unlock all 13 sheets.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
However, each sheet has to be locked seperately which is tedious when it
comes to unlocking. Leaving the form completely unlocked is out of the
question. We would like to see a Protect ALL Sheets Same function so that
you can set the cells to locked or unlocked, and then protect either ALL of
the sheets in a workbook with exactly the same protection, or even better,
you can choose which sheets you want to fall under the protection. AND, you
can still protect the other, unprotected sheets individually. (E.G. Sheet 1,
can select unlocked cells only, Sheet 2-14, can select unlocked cells, insert
or delete rows, format colums, sort and filter.)
The Protect ALL Sheets Selected would only require entering the password
once lock and unlock all 13 sheets.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions