I have a label in my sheet, in front of a chart. I can clearly see it when I have the sheet open. It has it's PrintObject set to true. Still it doesn't appear in the printout. I bring it explicitly in front of everything with: Shapes.Item(1).ZOrder msoBringToFront So, besides PrintObject being false and being behind of something, what's the possible reasons for a label object not printing?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Reasons for label not printing?

Thread starter Jaymond Flurrie
Start date Aug 8, 2011

Jaymond Flurrie

Well-known Member

Aug 8, 2011

I have a label in my sheet, in front of a chart. I can clearly see it when I have the sheet open. It has it's PrintObject set to true. Still it doesn't appear in the printout.

I bring it explicitly in front of everything with:

Code: