Can anyone tell me if there a way to apply password using vba while a running macro requesting.
J Jana New Member Oct 13, 2015 #1 Can anyone tell me if there a way to apply password using vba while a running macro requesting.
Chihiro Excel Ninja Oct 13, 2015 #2 Can you give bit more detail? Did you want password before the macro is run. Or is it to protect the VBA project or workbook? It's all possible, but how you approach it will be quite different.
Can you give bit more detail? Did you want password before the macro is run. Or is it to protect the VBA project or workbook? It's all possible, but how you approach it will be quite different.
J Jana New Member Oct 13, 2015 #3 Actually my team having a macro which should run daily basis, once we refresh the pivot tables it will ask password for 6 or 7 times..
Actually my team having a macro which should run daily basis, once we refresh the pivot tables it will ask password for 6 or 7 times..
Chihiro Excel Ninja Oct 13, 2015 #4 That sounds more like data connection password to database. What is it that you are trying to accomplish?
That sounds more like data connection password to database. What is it that you are trying to accomplish?
J Jana New Member Oct 13, 2015 #5 Its the same password which we give all the time, is there any way to doing the same using macro
Chihiro Excel Ninja Oct 13, 2015 #6 Yes. But depends on what type of password it is. Is it Password Protection on the sheet? Or is it some other password? Also, can you upload sample file with the code and sample data?
Yes. But depends on what type of password it is. Is it Password Protection on the sheet? Or is it some other password? Also, can you upload sample file with the code and sample data?
J Jana New Member Oct 14, 2015 #7 Thanks a lot for your time chihiro, My team planning to change the template. So now the automation is dropped. Thanks for time again...
Thanks a lot for your time chihiro, My team planning to change the template. So now the automation is dropped. Thanks for time again...
