Lock Size of WMP Object in Spreadsheet

**R_S_6** · 05-28-2009, 07:00 AM

Hi All,

I am having difficulty with a Windows Media Player (WMP) object in my spreadsheet. I go to design mode and set the desired size of the object in the spreadsheet; I then save and exit. Next time I open the file the object is much smaller. In fact every time I open the spreadsheet; save the spreadsheet and exit it gets smaller and smaller!

Any ideas as to how I can LOCK the bugger in place - ideally by using the corner points of the cells - For example Top Left Corner of A1 to Bottom Right Corner of T36.

Any help appreciated.
Cheers,

**split_atom18** · 05-28-2009, 10:19 AM

I don't know how to lock it, but you could prolly use vb to resize it everytime you open the spreadsheet.

Hope this helps,

Dan

**ab101** · 11-21-2013, 11:34 AM

Originally Posted by split_atom18

I don't know how to lock it, but you could prolly use vb to resize it everytime you open the spreadsheet.

Hope this helps,

Dan

here is the code

Please Login or Register  to view this content.

**arlu1201** · 11-21-2013, 12:31 PM

ab101,

Not likely that the original poster will return after so long.

Nevertheless, welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.