Printing of option buttons
 

I have a file that contains 3 option buttons on one of the sheets. Printing
of this sheet is prevented except via a command button on the sheet, which
activates a custom print Sub that I wrote. (I used the BeforePrint event and
a Boolean variable to restrict this). For some reason, the hard copy prints
of this sheet do not show which of the 3 option buttons is currently
selected. The option buttons are printed, but the "hole" for each one is
empty in the print even though one is clearly selected on the screen.

I have another file with an apparently identical situation in which the
print DOES show which button was selected. I cannot for the life of me see
what's different about the two setups. I know that this possibly an unusual
situation, but I'm just hoping that someone somewhere in the solar system has
seen this before and knows what's going on. I'll bet it's something really
simple.

PS: It's nothing to do with whether the "Print Object" property is ticked.
It is ticked for all of them in both files. And there is nothing in the
custom Print subs that is doing this. I am using the standard
"Selection.PrintOut Copies:=1, Collate:=True"

We're using XL2007 in compatibility mode. The file structure is 97-03.


Time is just the thing that keeps everything from happening all at once

Printing of option buttons
 

Just a few questions...

Does it show up ok if you print preview?
Does it show up on the paper if you use a different printer -- maybe even a
different model of printer (with a different printer driver)?
If you clean up your windows temp folder, does it work ok?

Close excel
Windows start button|run
type:
%temp%
and hit enter

Clean all those files that you can. (You may have some files in use, so skip
those.)

Then try your workbook again.

This is a complete guess...

I bet you're using optionbuttons from the control toolbox toolbar. If that's
true, you may want to try a test using optionbuttons from the Forms toolbar.
(If you have code that uses these, that'll have to change.)

I've found the controls from the Forms toolbar much better behaved.

But...

if you're using the optionbuttons from the Forms toolbar, try a test with
optionbuttons from the control toolbox toolbar.



Neptune Dinosaur wrote:

I have a file that contains 3 option buttons on one of the sheets. Printing
of this sheet is prevented except via a command button on the sheet, which
activates a custom print Sub that I wrote. (I used the BeforePrint event and
a Boolean variable to restrict this). For some reason, the hard copy prints
of this sheet do not show which of the 3 option buttons is currently
selected. The option buttons are printed, but the "hole" for each one is
empty in the print even though one is clearly selected on the screen.

I have another file with an apparently identical situation in which the
print DOES show which button was selected. I cannot for the life of me see
what's different about the two setups. I know that this possibly an unusual
situation, but I'm just hoping that someone somewhere in the solar system has
seen this before and knows what's going on. I'll bet it's something really
simple.

PS: It's nothing to do with whether the "Print Object" property is ticked.
It is ticked for all of them in both files. And there is nothing in the
custom Print subs that is doing this. I am using the standard
"Selection.PrintOut Copies:=1, Collate:=True"

We're using XL2007 in compatibility mode. The file structure is 97-03.

Time is just the thing that keeps everything from happening all at once

--

Dave Peterson