asked on

Combo Box turned into a picture when spreadsheet emailed to user

I distributed an excel file (.xlsm) to many people via email and one emailed me back saying a combo box didn't work.

When I looked at her file, the combo box had turned into a picture! Any idea what would cause such a thing? Could this be due to a missing ActiveX reference on her machine?

Zac Harris

I've had this happen after applying those amazing things Microsoft swears by (the updates :) )

This often happens also when you create the workbook in one version of Excel and the user opens it in another version.

Try closing Excel on the problem PC and delete the MSForms.exd file from the following places:

C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd

C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd

C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd

Davisro

ASKER

So this template went to many people. So when they open it from email, it opens as an unsaved temporary file. Can I programmatically delete these user files when my file opens, or use an environmental variable to make the Temp file open differently?

I created the file in Excel 2010, but I don't know what version of Excel would cause the temp file to open using these Excel 95 (v.8,0) files.

Would it be anything pre- Excel 2003 or just any version different than 2010?

Zac Harris

Only if they don't already have Excel open and only if its your environment to delete things....IT people are picky like that haha

Davisro

ASKER

Turns out this employee opened the file on a Mac using Excel 14.1.0

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Davisro

ASKER

Thanks guys