ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invisible/unfindable Comboboxes creating .emf file problem... (https://www.excelbanter.com/excel-programming/286705-invisible-unfindable-comboboxes-creating-emf-file-problem.html)

Wexler

Invisible/unfindable Comboboxes creating .emf file problem...
 
I've been working on an old program, changing all the comboboxes on
each sheet to just a data validation list dropdown in order to
eliminate the .emf temp files. I have deleted every combobox, but I
still get 30 .emf files that are images of the comboboxes every time I
open the workbook.

I have unhidden every sheet, column, and row, and cannot find any.

I have run a sub to iterate through every sheet.shapes(),
sheet.names(), and sheet.OLEObjects(), but cannot find any comboboxes.

Does anyone have an idea of where they are or why the .emf files are
being created???

Thanks for anyone's help.


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com