Zooming issue with Windows forms controls on a Excel Worksheet

Question

Hi,

I have few windows form controls over a Excel Worksheet. The controls work as expected with Excel zoom @ 100%. But any zoom level other than 100 will not work, though the controls are enabled; I'll get a message saying "Windows forms controls are disabled."

I learnt from the following link http://msdn.microsoft.com/en-us/library/ms178765.aspx that its the limitation of Windows form controls on a excel worksheet.

Is there any workaround so that i can make these controls work with any zoom level?

Please suggest.

Thanks in advance.

Regards,

Subhash Sreenivasachar.

Answer 1

 

Hi Subash,

I don't think there are any fixes made from Microsoft VSTO end.I had also same issue logged from Production clients. :(

Wait for some experts say on this.

Thanks

Dwipayan 

---

Dwipayan Das

Answer 2

Hi Subash,

Thank you for posting and we are glad to help with you.

After reading your post, I did the test and also reproduced your issue. From the document your provided, I knew that the Winform controls are not recommended to use.

And here is the thread about the same issue for you to take reference:

http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/2e708a1f-d833-4db6-9085-183147e45894 , and some experts said it is by design.

I hope these can help you and feel free to follow up.
Best Regards,

---

Bruce Song [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

Thanks, Bruce.

I agree the behavior is by design of Windows Form Controls over Excel Worksheet. However, the link you provided isn't of much use for me. I still dont have work around for this issue.

Regards,

Subhash Sreenivasachar

Answer 4

Hi Subhash

There is no workaround - the user has to work in Excel at 100% in order to use WinForms controls on the document surface.

BTW the better place to ask questions specific about the VSTO technology would be the VSTO forum:

http://social.msdn.microsoft.com/Forums/en-US/vsto/threads/

---

Cindy Meister, VSTO/Word MVP

Answer 5

Thanks, Cindy

 

Regards,
Subhash S

Answer 6

Bruce,

You misunderstood the document Subhash linked to. It is only certain properties and methods that are not recommended for use, not WinForm controls per se.

Nathan