Hi Guys (again and again)
I have a macros that feeds in 100s of formulas into a template that it opens (xl). What happens is that the Macro takes the input from some drop downs like , I pick January, Actual..etc and the Macro opens the Template Report and fills formulas accrodingly. These formulas are links to other Xl files. The problem is tha by design I had to secure the files with passwords. So I ended up opening every file before I fill the formulas and closing it after I fill the formulas.
Is there a way around this?
Pls advise and Thanks
I have a macros that feeds in 100s of formulas into a template that it opens (xl). What happens is that the Macro takes the input from some drop downs like , I pick January, Actual..etc and the Macro opens the Template Report and fills formulas accrodingly. These formulas are links to other Xl files. The problem is tha by design I had to secure the files with passwords. So I ended up opening every file before I fill the formulas and closing it after I fill the formulas.
Is there a way around this?
Pls advise and Thanks