copy and delete command button

M

Mark Kubicki

i have a worksheet with a command button

i then copy the worksheet, and the command button comes with it, which is
good

i then want to remove the command button's occurrence on the original
worksheet

however, when i use the command:

Worksheets(iCtr).Shapes("cbNextSheet").Select
selection.cut

the button is completely removed from the project, including the copy of it
on the new sheet (which i wanted to keep -with the same name as the original
to trigger the same application.run procedure(), as the original...)
 
Top