Delete a button after saving

Closed
alan - May 29, 2009 at 03:44 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 1, 2009 at 03:36 AM
Hello,
i have a macro runing to create a new workbook from a active sheet but when i m saving the data to the new workbook the command button appear how i can remove this command button in the new workbook

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 1, 2009 at 03:36 AM
Hi

Use activeworkbook.sheets("SHeetname").Commandbuttons("Name").delete

Let me know whether this helps
0