remove all code and objects

[kevster]

Hi all

I want to be able to copy sheets from my master file to another file twice a week. each sheet as command buttons on it link to code. when i copy the sheets i want to be able to remove all objects and any associated code so when i email the new file it wont ask the user at the other end if he/she wants to enable macros. do i ahve to delete each object seperate or is there a way to remove or objects in on go.

any help appreciated

 

[sweater_vests_rock]

kevster.

do i ahve to delete each object seperate or is there a way to remove or objects in on go.

ActiveSheet.DrawingObjects.Delete

removes all objects in one go.

to remove code, see chip pearson's explanation for working with the VBE here.

cheers. ben.