Paste Special in protected sheet

[Sharon C]

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?

 

[Gord Dibben]

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

 

[Sharon C]

Thanks - it works great