Copying sheets

[John Young]

How do I copy a sheet so that it also copies any buttons/event handlers/vba
code that is associated with that sheet?

TIA

John

 

[Don Guillett]

try
right click on sheet tab>move or copy>create a copy

 

[John Young]

Sorry, I should have mentioned that I was trying to use VBA..

Thanks

John

 

[Don Guillett]

John, Have you learned how to use the macro recorder?
I just recorded this. It can be shortened by eliminating the 1st line
entirely.

Sub Macro2()
Sheets("Sheet1").Select
Sheets("Sheet1").Copy After:=Sheets(5)
End Sub

 

[John Young]

LOL, I always forget about the macro recorder... Thanks for refreshing my
memory..

John