Santaflare
New Member
- Joined
- Jan 4, 2017
- Messages
- 15
Hi,
-I've inserted a Windows Media Player Control in a xlsm-spreadsheet, to which I've linked a looping video presentation.
Since the file is supposed to function as an introduction to my field of work, I've written code to switch seamlessly between sheets so that the user can jump to different subjects by pressing a button.
To make a smooth transition between the sheets, I've coded a "reverse-fading" rectangle shape to gradually appear (which has the same color as the sheet background). This enables me to make the switch between the sheets and the re-fade a similar shape on the following sheet.
Now to my problem:
For some reason it's impossible to change the sort order of the WMP Control once a linked video has been added in the option field. Even if the link is cleared I still can't hide the control behind the filled rectangle, such as I can with all other content on the sheet. This is only the case once a link has been added to the control - before this, it is possible to hide it behind other inserted objects.
Does anyone has in idea how to solve this annoying problem?
(So far I've gotten around it by coding a change in the control's visibility, but this isn't nearly as neat as I would like, since the transition from visible to hidden is instantaneous instead of more gradually.)
Any help would be greatly appreciated!
-I've inserted a Windows Media Player Control in a xlsm-spreadsheet, to which I've linked a looping video presentation.
Since the file is supposed to function as an introduction to my field of work, I've written code to switch seamlessly between sheets so that the user can jump to different subjects by pressing a button.
To make a smooth transition between the sheets, I've coded a "reverse-fading" rectangle shape to gradually appear (which has the same color as the sheet background). This enables me to make the switch between the sheets and the re-fade a similar shape on the following sheet.
Now to my problem:
For some reason it's impossible to change the sort order of the WMP Control once a linked video has been added in the option field. Even if the link is cleared I still can't hide the control behind the filled rectangle, such as I can with all other content on the sheet. This is only the case once a link has been added to the control - before this, it is possible to hide it behind other inserted objects.
Does anyone has in idea how to solve this annoying problem?
(So far I've gotten around it by coding a change in the control's visibility, but this isn't nearly as neat as I would like, since the transition from visible to hidden is instantaneous instead of more gradually.)
Any help would be greatly appreciated!
