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?

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?

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?