View Single Post
 
Old 11-21-2013, 03:17 AM
funkyfido funkyfido is offline Windows XP Office 2007
Novice
 
Join Date: Jun 2013
Posts: 24
funkyfido is on a distinguished road
Default

This is the code I have changed to but still getting problems.
Code:
Sub test()
Workbooks.Open Filename:="c:\My Documents\Try this.xlsm", Password:="one", WriteResPassword:="two"
ChDir "c:\New\"
ActiveWorkbook.SaveAs Filename:= _
"C:\My Documents\New\Try this 1.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Sheets("sheet1").Activate
ActiveSheet.Unprotect Password:="Test"
End Sub
Reply With Quote