Hi all

I want to run simple macro, where it copies a sheet into another new workbook. I want it to prompt the user to choose a specific sheet in the workbook to copy.

See below basic macro, at the moment its pointing to a particular sheet, I want the user to enter 04-07-13 then say OK and macro continues.

Sub Macro2()
'
Sheets("04-07-13").Select
Sheets("04-07-13").Copy
Range("A1").Select

Windows("xxxxx xxxxx TEMPLATE.xlsm").Activate

End Sub

Many thanks, John