Thread: Paste Special in protected sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote