On Feb 11, 6:34*pm, AB wrote:
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