Z
Zone
I'm using VBA to copy a range from a worksheet in one workbook to a
worksheet in another workbook. The range I'm copying from has buttons
that I don't want to copy. Can I copy the range without copying the
buttons? Alternately, can I delete only the buttons in the copied
range when finished copying (to prevent deleting buttons already on the
destination sheet)? The buttons on both sheets were created with the
Forms menu. ExcelXP (2002). I cannot control the properties of the
buttons in the source file. TIA, James
worksheet in another workbook. The range I'm copying from has buttons
that I don't want to copy. Can I copy the range without copying the
buttons? Alternately, can I delete only the buttons in the copied
range when finished copying (to prevent deleting buttons already on the
destination sheet)? The buttons on both sheets were created with the
Forms menu. ExcelXP (2002). I cannot control the properties of the
buttons in the source file. TIA, James