Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error: Can't Shift Objects off Sheet | Excel Discussion (Misc queries) | |||
Imported objects | Excel Discussion (Misc queries) | |||
How do I put drawing objects behind text/cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
Help - Cannot shift objects off sheet problem | Excel Discussion (Misc queries) | |||
Vlookup / Objects help XL2003 | Excel Discussion (Misc queries) |