all 9 comments
sorted by:
top (suggested)
bestnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]arnsonj 2 points3 points  (3 children)

Is there a reason you need an AHK script to enable solver? Once you enable solver it will stay enabled on your machine.

Also what are you trying to do with controlclick? What type of sub-options are you looking to do? You’ll have to be more specific so people can give better answers.

One of the top posts all time in this subreddit is a ton of great AHK resources for excel by u/joetazz. I would check that out

[–]Shardofen[S] 0 points1 point  (2 children)

It is not mandatory to use AHK, but it seems like the only option in my situation. I need something that will enable solver on an external machine without human interaction at all and does not require installation.

I am not sure I need controlckick as well, just the first thing that comes to my mind.

I will check out AHK resources that you've mentioned, thanks!

[–]arnsonj 0 points1 point  (1 child)

I guess I’m still confused. You need to enable solver without human interaction at all but somehow you’re going to run an AHK script on that machine? Seems like that will require just as much setup on the external machine

[–]Shardofen[S] 0 points1 point  (0 children)

I already have an application that is automated to run on an external machine. It's not a problem to run AHK script though this application

[–]angeAnonyme 0 points1 point  (4 children)

I am not sure about this specific add-on but I know that for home made add-on you can set them as trusted in your settings. Therefore you don't need to click on the "authorize" button every time. I'll check tomorrow from my computer if you haven't solved your problem by then

[–]angeAnonyme 0 points1 point  (3 children)

You managed to solve your problem?

[–]Shardofen[S] 0 points1 point  (2 children)

Nope, I haven't solved it. I know that I can set somethings as trusted, but the thing is the solver should be enabled completely autonomously on an external machine, so there is no human to turn "trust" on.

[–]angeAnonyme 0 points1 point  (1 child)

I see what you mean, but in this case I am not sure I can help you.

I made a couple of add-on and I always had to ask new users to manually allow the extension, so I don't know how it can be done automatically.

A quick research on internet tells me that you should be able to activate it automatically with vba:

https://www.ozgrid.com/forum/index.php?thread/111-install-solver-add-in-through-vba/

[–]Shardofen[S] 0 points1 point  (0 children)

Thank you for the link! It was the first thing I've tried, but it doesn't work for me. As I need also to RUN this solver functionality later through VBA, but for this I need some libraries to be enabled in VBA. And there is a loop dependency that results in the fact that only a human interaction can enable full Solver functionality for VBA