Simple button & macro question

C

Cook

I have added a button to a template tab that simply copies the entir
template and makes a copy and moves it to the end. I have also create
the code to make that happen. But, my question is this... is i
possible to modify the code so that it copies everything but th
button?

Or do I need to put the button on a different sheet all together
 
S

Simon Lloyd

You could always delete the object on the activesheet (it will be th
activesheet when you copy and move it), upload your workbook here so w
can see your structure as well as whether the button is of the form
toolbox or not
Cook;214695 said:
I have added a button to a template tab that simply copies the entir
template and makes a copy and moves it to the end. I have also create
the code to make that happen. But, my question is this... is it possibl
to modify the code so that it copies everything but the button

Or do I need to put the button on a different sheet all together
Click to expand...
Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
past the submit button and you will see the Manage Attatchments button
this is where you get to add files for upload, if you have any troubl
please use this link or the one at the bottom of th
any page

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
D

Don Guillett

Sub copytemplatewoshape()
Sheets("Sheet6").Copy after:=Sheets(Sheets.Count)
ActiveSheet.Shapes("Rectangle 1").Cut
End Sub
 
Top