Simple button & macro question
 

I have added a button to a template tab that simply copies the entire
template and makes a copy and moves it to the end. I have also created
the code to make that happen. But, my question is this... is it
possible 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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58955

Simple button & macro question
 

You could always delete the object on the activesheet (it will be the
activesheet when you copy and move it), upload your workbook here so we
can see your structure as well as whether the button is of the forms
toolbox or not!
Cook;214695 Wrote:
I have added a button to a template tab that simply copies the entire
template and makes a copy and moves it to the end. I have also created
the code to make that happen. But, my question is this... is it possible
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?
Attatchments.

To upload a workbook, click reply then add your few words, scroll down
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 trouble
please use this link or the one at the bottom of the
any page.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58955

Simple button & macro question
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cook" wrote in message
...

I have added a button to a template tab that simply copies the entire
template and makes a copy and moves it to the end. I have also created
the code to make that happen. But, my question is this... is it
possible 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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58955