CODEWITHSUNDEEP
comboboxactivexobjectexcel-365
Mdarende
Mdarende

Reputation: 739

The active x comboboxes in my office-365 excel worksheet changing size randomly when screen changes, or I open the workbook from other computer

I have a macro enabled excel-365 workbook (xlsm) and there is a problem that I cannot fix since months. I have read several entries on different platforms but none of them fixed my problem:

I am using mandatorily active x comboboxes in my workbook. Form controls have not the required flexibility and options that I need. The workbook is in a shared directory, so I can open it in my company, and also from home when I work home office. I get following problems:

  1. When I work with the workbook on same computer and monitor for a while everything works normally fine. But when I change just monitor (lets say I am presenting my screen on another monitor or projector), the comboboxes size randomly change when I click on them. You can't imagine what a big shame it is when you make a presentation to several people to show your project.

  2. Last weekend I opened the workbook from another computer (at home) and made same improvements (not related to comboboxes) everything worked again fine, but on Monday when I opened the file again from my office computer the same problem occured again.

What I have tried:

a) I have set option "Don't move or size with cells" b) I have set the size and position of all comboboxes when Workbook opens. (it got even worse in this case, because I think there is missmatch between what I set in code and what the real sizes are, so the properties window of the comboboxes are coming empty in this case)

Currently I have written following code for all comboboxes in the workbook open event, I thought this solved my problem but unf. it happened again after a long time, when I opened the sheet from another computer:

ws1.Shapes("ComboBox3").Height = 30
ws1.Shapes("ComboBox3").Width = 116
ws1.Shapes("ComboBox3").Left = 378
ws1.Shapes("ComboBox3").Top = 108
ws1.Shapes("ComboBox3").Placement = xlFreeFloating

' I have done similar settings for all other comboboxes

I have to present my project to my manager on thursday and I don't know what I should do.

Upvotes: 0

Views: 22

Answers (0)

Related Questions