if i save as the excel file, macros path changed
hi,
thanks for answer
i tried your request to use filecopy command but filecopy command not run
because plan.xls was opened.
The user work on plan.xls and save as other filename when worik is finished.
i say please save as other filename to the user because i don't want the
user destroy the macro unknowingly
"Tom Ogilvy" wrote:
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
|