SimenSikkeland
New Member
- Joined
- Sep 2, 2014
- Messages
- 1
Hello all,
I have currently been implementing a VBA code allowing for the installation and VBA referencing of the "Solver".
This code runs when the workbook is opened. This code is the only code I have in the "ThisWorkbook" object, but I have a lot of code connected to each specified sheet.
In order to run the code regarding the "Solver" the VBA must be unprotected, and I have read a great deal regarding this matter, and came to the conclusion that using "SendKeys" was not an option for me.
So my question is: Is there a way to protect/hide the code in the different sheets, and still be able to have the VBA Project (or just "ThisWorkbook") unlocked in order for the "Solver" code run properly?
If anyone has some other suggestion to how this might be done, I am all ears!
I have currently been implementing a VBA code allowing for the installation and VBA referencing of the "Solver".
This code runs when the workbook is opened. This code is the only code I have in the "ThisWorkbook" object, but I have a lot of code connected to each specified sheet.
In order to run the code regarding the "Solver" the VBA must be unprotected, and I have read a great deal regarding this matter, and came to the conclusion that using "SendKeys" was not an option for me.
So my question is: Is there a way to protect/hide the code in the different sheets, and still be able to have the VBA Project (or just "ThisWorkbook") unlocked in order for the "Solver" code run properly?
If anyone has some other suggestion to how this might be done, I am all ears!
