0

I have a coursework half of which is in excel. I added a bonus functionality using macros called by a button. However, I found that my teacher would have to go through all the settings I had to do in order to run the macros - adding Solver to excel and then referencing it in VBA. Is it possible to do all of that in the macros so that my teacher could just click the button and see the result? Thank you!

YowE3K
  • 23,852
  • 7
  • 26
  • 40
Kristiyan Tsvetanov
  • 967
  • 12
  • 22
  • 2
    Allowing a VBA project add references programmatically requires special trust granting which is even worse. [You can do it](https://stackoverflow.com/a/9880276/11683), but you should not. – GSerg Oct 22 '17 at 18:44
  • Thanks GSerg! You could write it as an answer so that I could accept it... – Kristiyan Tsvetanov Oct 22 '17 at 18:53
  • It's not okay to post a link to an existing question as an answer. If https://stackoverflow.com/a/9880276/11683 answers your question I would rather close as duplicate. – GSerg Oct 22 '17 at 18:59

0 Answers0