flash movie on userform doesn't play when code is running

abhay_547

Board Regular
Joined
Sep 12, 2009
Messages
179
Hi All,

I have a userform with the modal setting changed so that it stays open
on screen whilst the rest of my code is running.

The userform has a shockwave flash object added and the swf movie
happily plays when you f8 step thru the code, however when it gets to
code the requires some processing (ie running a SQL extract), the
image locks.

This means that when you play the code real time (not step thru), the
image is permanently locked.

Any ideas how to get around this?

I used to have an avi file in an animation control, but a recent MS
patch has made this control no-longer a trusted source which is why
i'm now going down the flash route.

Thanks for your help in advance. :)
</pre>
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,136,330
Messages
5,675,152
Members
419,552
Latest member
jsanjur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top