G
GJones
Hi Paige;
You could try using an Aut
pen macro instead of the
workbook object or changing the code in either case to
reading the workbook name and then skipping all the
routines if it is not the original name. It might look
something like this;
Sub try()
If activeworkbook.name = "TheOrigianlName.xls" then
'do the stuff
End If
End Sub
Thanks,
Greg
You could try using an Aut
pen macro instead of theworkbook object or changing the code in either case to
reading the workbook name and then skipping all the
routines if it is not the original name. It might look
something like this;
Sub try()
If activeworkbook.name = "TheOrigianlName.xls" then
'do the stuff
End If
End Sub
Thanks,
Greg