Hi,

I'm have a problem with a Excel file with macro's which is working fine in Office 2013 but is not working on Office 365. I'm using Windows 7 and in Excel I already enabled all marco's without warning, but still I'm enable to click on the button's or checkboxes. In Designer Mode I've checked the format of the objects and I've noticed the existing checkboxes formats are not there.

- Right click on button / checkbox / Format control => No tab with properties / All Text and Control

If I'm creating a new checkbox for example in this Excel sheet the format options are in the format control screen:

- Right click on button / checkbox / Format control => 3 tabs with properties / All Text and Control

Seems like the Office 365 is not recognize the button's and checkboxes made in Office 2013? Could anyone advise me to solve this problem?

Kind Regards

Wouter - WMS consultant

Hi,

As far as I known, the macro/Active X control can be used well both of the Office 2013 and Office 365.

Would you like to share us a sample file that created in Office 2013? I'd like to test it. You can send it via Email (ibsofc@microsoft.com).

If you have any update, please feel free let us know.

Regards,

Hi,

As far as I known, the macro/Active X control can be used well with both of the Office 2013 and Office 365.

Would you like to share us a sample file that created in Office 2013? I'd like to test it. You can send it via Email (ibsofc@microsoft.com).

If you have any update, please feel free let us know.

===========

Update:

I have received your mail and attachment. Then, I tested it, I found the probably reason.

You were using ActiveX controls in the sample file, and them displayed 4 tabs in Format control dialog box. Next, you created a new Form control, it displayed 7 tabs.

You were using the two type of controls. ActiveX controls and Form controls are different.

Form controls

Form controls are the original controls that are compatible with earlier versions of Excel, starting with Excel version 5.0. Form controls are also designed for use on XLM macro sheets.

ActiveX controls

ActiveX controls can be used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. In general, use ActiveX controls when you need more flexible design requirements than those provided by Form controls. ActiveX controls have extensive properties that you can use to customize their appearance, behavior, fonts, and other characteristics.

For more detail information, please refer to the following link:

https://support.office.microsoft.com/en-us/article/Overview-of-forms-form-controls-and-ActiveX-controls-on-a-worksheet-d101804a-0f84-43ad-8cb2-e19277b8e3fb?CorrelationId=0e7129b7-8ea2-458c-af14-a99292d300b9&ui=en-US&rs=en-US&ad=US

Hope it's helpful.

Regards,

Hi George,

Thanks a lot for your reply ! I've checked and there is indeed a difference between ActiveX and Form in my Excel 365. But I was wondering, as I created this marco Excel file in 2013 and it worked fine there, is there a possible solution to convert the Excel file 2013 to Excel 365 in a way the checkboxes / buttons are recognized as Form Controls? Or can I change some value in the properties to change the ActiveX into Form control?

Thanks in advance.

Kind Regards

Wouter

Hi,

As far as I know, unfortunately, we can't convert the existing ActiveX control into Form control. We may need to re-build it.

Regards,

Hi George,

I just had a breakthrough! I discovered I could not create an ActiveX form in Office 365 because I've get the error message: 'Cannot Create Object'. Now I've did a litle research and discovered that it is caused by the old MSForms.exd file in the file location: C:\Users\<USERNAME>\AppData\Local\Temp\Excel8.0

If you delete this file in the folder, Excel will create a new 'updated' EXD file (make sure Excel is closed) and on the next startup of Excel 365 the macro's are working again !!

I hope this update will help other users of Office 365 with the same problem, Thank you George for your input on this issue.

Kind Regards

Wouter Six