| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special in protected sheet
I need to perform copy paste special to replace formulas with values in a
protected sheet. Is there a macro that will unprotect and perform copy paste special? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in protected sheet
After selecting and copying the cells, run this macro to pastevalues in
place. To pastevalues elsewhere, just select a single after after copying then run the macro. Sub pasteit() ActiveSheet.Unprotect Password:="pword" Selection.PasteSpecial xlPasteValues Application.CutCopyMode = False ActiveSheet.Protect Password:="pword" End Sub Gord Dibben MS Excel MVP On Tue, 9 Sep 2008 19:28:06 -0700, Sharon C <Sharon wrote: I need to perform copy paste special to replace formulas with values in a protected sheet. Is there a macro that will unprotect and perform copy paste special? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in protected sheet
Thanks - it works great
"Sharon C" wrote: I need to perform copy paste special to replace formulas with values in a protected sheet. Is there a macro that will unprotect and perform copy paste special? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use macro(command button) paste special in 2nd sheet | Excel Worksheet Functions | |||
| Do not allow Copy/Paste Functionality in a Protected Sheet | Excel Worksheet Functions | |||
| Paste special into a filtered work sheet | Excel Worksheet Functions | |||
| How to paste objects in a protected sheet | Excel Discussion (Misc queries) | |||
| How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
