Temporarily override sheet protection
 

Hi, Does anyone know of an easy way to temporarily override the sheet
protection?

After copying a range - I want to paste into a protected sheet.

Rows("2:2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

Elijah

Temporarily override sheet protection
 

Elijah,

If it is password protected like a few that I work with, I use the following
code to un protect...

ThisWorkbook.Worksheets(p_Sheet).Unprotect ("password")

And then when I am done....

ThisWorkbook.Worksheets(p_Sheet).Protect ("password")

HTH, Dean.

"Elijah" wrote:

Hi, Does anyone know of an easy way to temporarily override the sheet
protection?

After copying a range - I want to paste into a protected sheet.

Rows("2:2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

Elijah