View Single Post
 
Old 02-09-2016, 08:19 PM
CPSmith CPSmith is offline Windows XP Office 2013
Novice
 
Join Date: Feb 2016
Posts: 3
CPSmith is on a distinguished road
Default

Okay I just realized it had this in there If ActiveWorkbook.ProtectStructure = True Or _
My_Range.Parent.ProtectContents = True Then
MsgBox "Sorry, not working when the workbook or worksheet is protected", _
vbOKOnly, "Copy to new workbook"
Exit Sub
End If

Guess that explains why it won't work on protected =) DOH!
Reply With Quote