Deleting a macro button in an output file

[AB]

Hi,
I've created a macro to save from a master file (.xlt file - contains
formulas) into one that contains only values ('slave' file - .xls, removing
all formula) and assigned it to a button using the form menu.

This button sits in the Master file.

However once the slave file is created the macro button is saved with it - i
want to remove the macro button as part of the programing - ie save file as
"filename'.xls with the macro removed so that other users of the slave file
won't have it to muck with.

Much thanks in advance
AB

 

[CurlyDave]

Hi,
I've created a macro to save from a master file (.xlt file - contains
formulas)  into one that contains only values ('slave' file - .xls, removing
all formula) and assigned it to a button using the form menu.  

This button sits in the Master file.

However once the slave file is created the macro button is saved with it - i
want to remove the macro button as part of the programing  - ie save file as
"filename'.xls with the macro removed so that other users of the slave file
won't have it to muck with.

Much thanks in advance
AB

try
Worksheets("Sheet1").Buttons.Delete

 

[Stringer]

Try

Code