View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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
|