On Windows the following code segment works fine however on a Mac, the Worksheets("worksheet").Copy command causes Excel to crash. I've see suggestions where using Worksheets("worksheet").UsedRange.Copy solves the problem, and in fact, the Mac does not crash, however I need the copied data in a new/separate worksheet just as the .copy command does. Using the .UsedRange part does not create the new workbook. The difficulty is that without creating the new workbook, the command following the copy shuts down the worksheet that the vba code is running from instead of closing the copied worksheet.

Any suggestions on code that could copy the entire worksheet, or even the cells with data, into a new worksheet that then becomes the active workbook?

Worksheets("Launch Map").Copy

ActiveWorkbook.FollowHyperlink _
     Address:=strFName, _
      NewWindow:=True