ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copy and delete command button (https://www.excelbanter.com/excel-programming/278893-copy-delete-command-button.html)

Mark Kubicki

copy and delete command button
 
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...)





All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com