Hi, I'm relatively new to Excel, but I'm trying to create a button to run a macro, that in turn, executes the Solver function. I created an "Optimize" macro, recorded me clicking on the Solver button, changed properties to Name=Optimize, and assigned it to the button. Problem is:

- When I click on the button, a compile error appears: Sub or Function not defined.
- VB highlights SolverOk
- Stretch goal: Adding an unprotect/protect worksheet function in the macro also

Not sure what I'm missing here. Help is appreciated!