What happens if you add the appropriate file extension to Book1, eg Book1.xlsm, or change Workbooks("Book1") to ActiveWorkbook?