Clicking yes when asked for permission to run active x controls

[kalle82]

Hi!

I have a userform in word with a button, that

- Inserts data into excel
- Runs a macro
- Fetches the data

But when running this, i always get popups that ask´s if i want to give my permission to run the active x control. Its kinda annoying
--Question--1
Can you program the macro to click yes automaticly
--Question--2
--Prologue--
Sometimes the question is into the windows taskbar, then users dont even know if they have been asked and they sit and wait for the question to come.
--Actual question--
--Can you force the popup to show on top of the userform?

 

[PHV]

force the popup to show
Have a look at the AppActivate instruction.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kalle82]

force the popup to show
Have a look at the AppActivate instruction.

Okay that part is fixed!

Is there a way to force the macro click yes when asked to run active X controls?

As im using another macro in an excel file it prompts me everytime and its annoys me to click yes.