Object unexpectedly changed in VBA project window - how to change back?

[JackDanIce]

Hi,

Working on a spreadsheet containing VBA, last night, closed it and it contained 1 Workbook object (ThisWorkbook) and several Worksheet objects)

Today, in the Project window, two worksheet objects have changed icons and showing as Workbook objects?!

This is causing an issue with a save routine autotriggered when file exists because it can't find the correct object and I keep receiving error:
Run-time error 429: ActiveX component can't create object

How can I reset the changed Workbook objects back into Worksheet as they're supposed to be?

TIA,
Jack

 

[RoryA]

That sounds like corruption to me.

 

[JackDanIce]

lol thanks Rory, but how can I isolate or identify the cause or find the corruption? It's not obvious

Code is fairly basic, only "complex" parts are reading/writing to an Access database.

 

[RoryA]

You can't really. If it were that simple, it probably wouldn't happen.

Do you use activex controls though?

 

[JackDanIce]

I know, ask an obvious question! This has totally baffled me as been working on this file for ages (without crashing/corruption issues)

No, avoid them due to issues with display and sizing, try to always use very basic buttons and form controls, if I have to.

 

[RoryA]

Got any COM add-ins loaded? Do you see the same thing with Excel in Safe Mode?

 

[JackDanIce]

Not that I know of, it's all meant to be "standard" Excel and "standard Access"