Right -clicking the sheet tab and choosing "move or copy" does that already.
If you must use a macro it sounds as if "ActiveSheet" is what you need..
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"phil-rge-ee" <
wrote in message
I need to move a sheet from one workbook to another workbook. I'd like to
create a button that uses a macro or vb script to accomplish this. I can
create the move macro, but the catch is that the sheet that needs to move
will have a different name every month. So I was thinking of the code popping
up a form that I could type the sheet name in that needs to be moved and it
will then move it. I'm familar with forms, text boxes, and basic VB, but need
some help with the code here. Thanks for any help you can provide.