My application copies a spreadsheet to create a second spreadsheet in the
same workbook, and massages the data in the second sheet. There are four
buttons in the first sheet, and I wish to hide three of them in the second
sheet. The button numbers of the first sheet change when they appear in the
second sheet. How can I identify the buttons in the second sheet so as to
hide them using the following statement: ActiveSheet.Shapes("Button
X").visible = False

--
Lon Sarnoff