Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add "Protect ALL Sheets" that is the same as "Protect Sheet"
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/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|