Excel 2016 Mac, VBA Editor, and Solver password issue

Question

I have Excel 2016 for Mac (Version 15.28) and I’m curious about something I see when using the VBA Editor. I have not used the VBA Editor before but I’m hoping to learn how to use it as I want to create my own Excel functions.

When I call up the VBA Editor using alt & F11, the list on the left-hand side of the box includes something labelled Solver (Solver.xlam). If I click on the arrow for this, I am asked for a VBA Project Password. As I have never before used VBA Editor or Solver, I wonder why I am asked for a password for something I haven't yet used. None of my passwords work - well, as I have never before seen or used this I'm not surprised but my curiosity has been awakened!

Many thanks

bsrmac

Answer 1

I don't know about avoid, VBA may turn out to be a big help for you. But the learning curve is steep. If you are not going to use solver, then just ignore what you have seen. The solver VBA linkage will have nothing to do with what you are doing and can be safely ignored.

Answer 2

n this case, you are being asked for the password to unlock the solver interface code supplied to Microsoft by a third party. They have 'locked" the code to prevent its inadvertent modification.

Answer 3

Hello Bob

Wow! That's got to be the quickest reply to anything I've ever asked on the web! (Not that I do much asking but impressive nevertheless). Also, it makes sense - another positive. Many thanks.

I guess, then, this is something that I just ignore and/or avoid? I'm just starting out with VBA so there's only a remote chance I'll ever use Solver, which seems way too advanced for me at this stage.

Regards

bsrmac

Answer 4

Many thanks, Bob - I meant avoid Solver - I'm on a journey with VBA! You've been really helpful.

All the best

bsrmac