Temporarily override sheet protection

  • Thread starter Thread starter Elijah
  • Start date Start date
E

Elijah

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
conso macro 0
define Range in vba using contents of a cell that is named 1
Copy Paste Macro not Pasting Values when Blank 3
Simplify Code for Copy/Paste Special 11
lenghty code 4
Error Message: "Can't Execute Code in Break Mode" 6
copy to new workbook 1

Back
Top