How to hide User interface login on Analysis with VBA code in excel (auto refresh data)

Hello,

I just want to send you my problem, if anybody can help me I will be grateful.

Here is my problem and my code:

When I launch this code everything work, but I have this user interface and I need to click on cancel for continue the code and to work.

1937741-wfajy.png

Does it possible to disable this UI? If yes what is the procedure plz? I check on forums and I don’t find a real solution about that. Some people talk about a “propreties” window but I don’t find it.

Best regards,

Tristan


here is my VBA code:

Please Login or Register  to view this content.

​Hello my problem is solved, I have created a VBS to check if window "analysis" is here then the script press escape, i think it's not the best solution but it's work.