Appearance of Controls misbehaving

S

Sophie

Hi - I'm having a peculiar problem with controls (there are 3 command
buttons) on my Sheet. One of the buttons, called cmdPrint, uses the
following code:

ActiveSheet.PrintOut Copies:=2, Preview:=True

This works exactly as expected. BUT, if I view the Preview, then click
'Close' before printing, there is a problem on the Sheet1. The Print button
looks fine, but the other two buttons appear distorted (about five times
taller than they were, and slightly wider). what's going on here? How can I
prevent this?

By the way, if I save and close the file then reopen it, all is back to
normal.
 
S

Sophie

re the posting I just sent - I've now set the PrintObject property of each
command Button to False. Now when I click cmbPrint, view the Preview, then
Close the Preview, the other two buttons don't distort as I've described
earlier, but they temporarily vanish. If I click in any of the sheet's
cells, the missing buttons magically reappear! I'm sure there must be a
simple explanation and a way to prevent this behaviour.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Installing Office XP SP3 introduced problems with controls 2
Distorted Fonts on Controls 2
Why am I getting 3 copies of the report on my screen? 1
Printer Control and Print/Preview Problems 3
Misplacement of controls on one machine but not others 2
Inheritance of controls and forms ... 2
Forms Fields not active for users 2
graph not showing on PDF export / print 1

Top