have your macro use the filecopy command to make the copy of plan.xls without
opening it excel.

--
Regards,
Tom Ogilvy


"Selim Ozbas" wrote:

hi,
i use public excel file( plan.xls). i run macro on plan.xls and save as the
file for copy-paste, change color vs. because i don't want to change public
excel files properties but i save as the file, changed public.xls macros path.

example
plan.xls have "olustur" macros but i save as plan.xls to plan-yedek.xls and
i open the plan.xls, plan.xls macros adress changed. plan-yedek!olustur.

How can i secure default settings. thanks