Update:

If i change the combo box, and then toggle to design mode and then go
to print preview, the correct signature image shows up. when i toggle
back out of design mode, it goes away. so, the code works, but only in
design mode. what am i missing?


wrote:
I've got 3 signatures inserted into image objects. I have the
visible
and printobjects options set to False in the properties dialog for
all
3. I have a combo box linked to a cell S2 and a range of signature
names. I want the employee to pick his signature from the combo box,
and only his signature to print out, but still not be shown on the
sheet. here's what I've got and it just doesn't work. not stopping
the code or kicking errors, but not setting the printobject to true
either. Thanks in advance.

Public Sub signatures()

Sheet2.jessiedinsig.PrintObject = False
Sheet2.chriswinsig.PrintObject = False
Sheet2.davidshawsig.PrintObject = False

If Sheet2.Range("S2").Value = "Jessie Dinwiddie" Then
Sheet2.jessiedinsig.PrintObject = True
ElseIf Sheet2.Range("S2").Value = "David Shaw" Then
Sheet2.davidshawsig.PrintObject = True
ElseIf Sheet2.Range("S2").Value = "Christopher Winlock" Then
Sheet2.chriswinsig.PrintObject = True
End If

End Sub

Private Sub SigInspect_Change()

Sheet2.signatures

End Sub