| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect but Allow Edit Ranges in Multiple Sheets
Hi, there!
Can anyone please help with a solution to the following problem: I have 20 similar workbooks with exactly the same worksheets that are just named differently. For example, Workbook 1 is East Division, and the sheets are New York, New Jersey, Massachusetts - they are exactly the same sheets. Workbook 2 is South Division, and the sheets are Florida, Alabama, Kentucky - again, same sheets as in East Division, etc. Here is my question. Is it possible to create a macro that would simultaneously allow users to edit range B1:B32 in each of the sheets AND protect each of the sheets within a workbook? Would this macro be applicable to all of the other 19 workbooks. Please help! I can't imagine having to go into each of the sheets in every workbook and manually set up "allow user to edit range" and "protect sheet" modes. It'll take me forever. Thank you in advance! E.P. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are there ways to protect multiple sheets at once? | New Users to Excel | |||
| Macro to protect multiple sheets? | Excel Worksheet Functions | |||
| Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
| How do I protect multiple sheets at one time? | Excel Worksheet Functions | |||
| How do I protect formula cells on multiple sheets? | Excel Worksheet Functions | |||
Threaded Mode
