ExcelBanter - Stop Command Button being copied to new Workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Stop Command Button being copied to new Workbook (https://www.excelbanter.com/excel-programming/357669-stop-command-button-being-copied-new-workbook.html)

Ledge

Stop Command Button being copied to new Workbook

Hi, I have some code which copies a sheet to a new workbook. Is there a
way to exclude command buttons being copied to the new workbook?

Thanks,
Dean

Jim Rech

Stop Command Button being copied to new Workbook

Application.CopyObjectsWithCells = False

--
Jim
"Ledge" wrote in message
oups.com...
| Hi, I have some code which copies a sheet to a new workbook. Is there a
| way to exclude command buttons being copied to the new workbook?
|
| Thanks,
| Dean
|

All times are GMT +1. The time now is 10:29 PM.