It is possible to send commands to ActiveX objects on other worksheets very easily, such as:
Worksheets("test").OLEObjects("TextBox1").Object.Value = ""
where "test" is the other worksheet name.
Is it possible to do the same if the object is an embedded WAV file?
To play an embedded WAV file on the same worksheet, the code might look like this:
![]()
Please Login or Register to view this content.
where "2" is the name of the target file.
Is it possible to modify this to replace 'ActiveSheet' with the name of another worksheet?
I've tried all the expected permutations without success - your help would be greatly appreciated.
Moderator Note:
Pls use code tags around your code next time as per forum rules.
Bookmarks