I have an Excel macro that creates new worksheets in the workbook.
After the new worksheets are created, the focus is on the last newly
created worksheet, but I would like it to be on the original
worksheet. What line of code can I add to the end of my macro to
accomplish this?

Hello Screamv,

The comment is a little incomplete, so let's expand on it slightly.

Adding a line near the top of the macro like
  oldSheet$ = ActiveSheet.Name
will capture the name of the sheet currently active (so the macro does
not need to assume a specific name).

Adding a line near the end like
  Sheets(oldSheet$).Activate
will activate the original worksheet using the name captured previously.

A complete example is something like the following:
Sub addSheet()
'
'   macro to add a sheet & return to the original one
'
    oldSheet$ = ActiveSheet.Name
    Worksheets.Add
    Worksheets(oldSheet$).Activate

End Sub

This adds a sheet prior to the currently selected sheet & then
activates that original worksheet.

Please make a clarification request if any part of the answer is
unclear or you need additional information to utilize this answer in
your worksheets. I would be glad to help.

Good luck with your work.

  --Maniac

Thanks, nice enhancement to the comment already posted.

Hi, noproblem ...

Sheets("Sheet1").Select     // "Sheet1" name of sheet that will be active

Thanks! That did the trick.