Skip to main content
May 17, 2017
Question

Excel 2013 VBA Shockwave Flash Object

  • May 17, 2017
  • 0 replies
  • 1775 views

I created a Excel 2013 Workbook with a User Form with a Shockwave Flash object. It works fine on the computer that I created the workbook on. Now when I pass this workbook to many other Excel users that do not have Flash installed, they get the message "cannot load an object because it is not available on this machine" and causes Excel to crash. What I would prefer to do is, in the Excel workbook_open event somehow test first to see if the Shockwave Flash object is installed and available in Excel on that computer and if so OK, otherwise if that object/control is not available I need to disable that control on the User Form to stop Excel from throwing that message/error/crash. Using VBA, is there an easy method to test this and if not installed an easy method to install it before the workbook fully opens/loads. I'd like to call the routine in the workbook_open event. I've posted this on several MS community sites and they said it is out of their scope.

This topic has been closed for replies.