Hi

Is it possible to copy a protected sheet to a new workbook as an unprotected sheet? My current code is

Sheets(strSheetName).Copy Before:=Workbooks("InvestorComparision.xls").Sheets("Setup")
but one file I work with is protected and I need to be able to change the sheet.

Thanks!