I'm looking for a code snippet to insert into an existing routine that will Open a workbook on my PC when:
  1. a specific range is selected on a specific sheet, and
  2. I do a Copy command with keyboard Ctrl+C.

The selected range to test if already selected would be B3:B15 on sheet "Specs" of the workbook.

Let me know if you need to see the existing code, but I think I can figure out where/how to insert it.

The code section that opens the file by selecting a menu of the macro is:
Dim str_xlsFile As String
Dim str_xlsFolder As String

str_xlsFolder = "C:\Users\myname\Documents\Litigation\reports\report templates\U&E Summary templates\"
str_xlsFile = str_xlsFolder & "Generic Summary Report.xlt"

Workbooks.Open Filename:=str_xlsFile, Editable:=True
Also - Why does the inserted Code section seem to be unclear? Previously, it was much easier to read.
Is there a setting to change or am I messing it up when pasting between the tags?

Thank you,
Delain