Reply to thread

Message: [QUOTE="Vacuum Sealed, post: 14093311"] Hi Swingleft You can do a google search for AllInternalPasswords.xls, it finds and removes protection. I have a protected WB/Sheet supplied by another company, I have my own version of it unprotected, I do my thing, then protect it when I am finished and save it the way they like it and send it on to them.. Something to ponder. Here is a snippet you can play with. Replace the Source** & Dest** references with your own... Windows("SourceWb.xls").Activate Sheets("SourceSh").Select Range("SourceRng").Select Selection.Copy Windows("DestWb.xls").Activate Range("DestCell").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False ActiveSheet.Protect Although, the Guru's will have a cleaner/faster way of copying the cells directly.. I'm nowhere near Guru status, and never likely to be, but it fun learning and helping others along the way.... Good luck HTH Mick [/QUOTE]