Print preview makes shapes vanish

**WasWodge** · 06-27-2011, 08:44 PM

Try
.ControlFormat.PrintObject = True
as part of the code for all objects but as Romperstomper implied earlier it is more likely to do with your default printer settings especially as it is working on other PC's. Does anyone share the same printer? If yes does it work on theirs?
I only suggest putting .ControlFormat.PrintObject = True in the code as despite what you say in post #11 in your last post they are showing as False, which suggests that it is going by the default printer settings

**Wongadob** · 06-28-2011, 03:23 AM

I think you have missed the point. I do not want the buttons displayed when printing. Only on the sheet. The print.object property only disabled them when printing which is correct. BTW the graph prints fine (which is classed as a shape, as does the company logo) it is only on return from printing that all shapes vanish. I did have some code which made all objects of type 1 (autoshapes, so only the buttons I have for macros) be invisible during printing. And then had the same code after printing re-enabling them.

As this was causing the problem I described, I asked for alternative solutions. It was then that I discovered the print.object property to disable during printing. So I decided to use that. so I removed all of my disabling and re-enabling code.

Print.object is supposed to only not show the shapes when printing, they should be visible at all other times. So as you say they are set to false which they should be, but they should still be visible on screen when returning from printing. They operate as if they are there. i.e. you can still click on where they are, but they are not visible, yet the visible flag is set to true. So they should be visible.

I will check out whether it has the same problem with others using the same printer. I also hope today that I should have some access to their IT guy to see if he can offer any reason as he has control over printer drivers, local installations etc.

Thanks, but please keep the ideas coming as this is really getting to me

**Wongadob** · 07-13-2011, 01:57 PM

I have still not found a solution to this! I am awaiting more info from the company, but if anybody else has any ideas in the meantime, they would be much apprectiated.

**Metal Head** · 07-13-2011, 02:09 PM

whoops wrong button

**jope** · 08-29-2011, 12:40 AM

I'm relatively new using Excel. Version 14.1.2.
I have a spread sheet composed with a top line of categories and the rest figures. There are no formulas except addition on the sheet. I highlighted and "set print area" but it only prints the top line of the spread sheet.
I cannot find a command to make it print what I have highlighted and designated as the print area.
Can anyone tell me how to solve this?
Thanks,
Jope

**arthurbr** · 08-29-2011, 03:30 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.