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

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

Try

Code:
--------------------
ActiveSheet.Buttons.Delete

--------------------


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62852