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