Delete a button after saving

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi

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

Let me know whether this helps