| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Protect A Worksheet But Allow Copying Columns
I need to protect a worksheet where I do scenario analysis. Each column is a
single scenario where some rows have inputs but most are protected. The trick is I need to be able to copy a column and insert it next to or somewhere on the worksheet while leaving the worksheet and the cells I want in the column that is being copied protected? Do I have to use VB to do this or is there another simpler way? If I have to use VB -- suggestion on how to do this easily are appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How Do I Protect A Worksheet But Allow Copying Columns
I would protect the worksheet, then provide a macro that did:
unprotect, copy, paste, reprotect If you record a macro when you do this, you'll be pretty close. KMH wrote: I need to protect a worksheet where I do scenario analysis. Each column is a single scenario where some rows have inputs but most are protected. The trick is I need to be able to copy a column and insert it next to or somewhere on the worksheet while leaving the worksheet and the cells I want in the column that is being copied protected? Do I have to use VB to do this or is there another simpler way? If I have to use VB -- suggestion on how to do this easily are appreciated. Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| How to password protect hidden columns and custom views in Excel | Excel Discussion (Misc queries) | |||
| can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
