Quick Question: Blue icons MS-Excel Objects in VBA editor

[Michael van den Berg]

Hey all,

Quick question,
What do the blue icons mean in the attached screenshot?
It breaks my file for some reason.

Although I have a back-up of the previous version, which doesn't have these blue icons, I would like to know what I did.

Gr.
Michael van den Berg

 

[Hui]

I've Never seen them and can't replicate them

So I've sent this to the experts and will revert as soon as I hear back...

 

[Michael van den Berg]

Thanks Hui,

Apparently it is not that quick of a question after all .
Curious about the result though if even the Ninja doesn't know... must have screwed up big time.

I don't know enough about VBA behaviour to know if this is related or not, but I put a freeze pane / line below the headers of my main table. I call this table a lot in macro's with [tablename[header1]] and such. Maybe this is causing a problem?

If necessary I can supply a sample file later.

Gr.
Michael

 

[Luke M]

A sample would be interesting. Like Hui, I've no idea what that is...curious as well to know more.

 

[Hui]

From Daniel Ferry - MVP
"I've seen the worksheet object icons split like this before.
I do not know what causes it.
If I remember correctly, the fix is to copy the sheets to a new workbook."

 

[Michael van den Berg]

@Luke M Sorry it has a lot of sensitive data
@Hui I'll rebuild from a back-up file I have. Thanks for the help.

Thanks for replying to my question, ninja's.

Gr. Michael