![]() |
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