Warning when running the macros

[shruthidwh]

Hi,

I am running some macros in a batch, sometimes I am getting Actice X control warning,because of these i have to manually click ok, I have attached the warning. Please let me know how can I avoid this warnings when executing macros.

Regards,
Shruthi

[venkat1926]

Try this
at the beginning of the code (after "sub......") type this statement

Please Login or Register  to view this content.

again at the end (before end sub ) type this statement

Please Login or Register  to view this content.

and now run the macro and see