I haven't done it in quite some time, but I believe you can add a control to
the CELL commandbar.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"ExcelMonkey" wrote:

I want to create a right click option in Excel that I can use in every
spreadsheet, that allows me to copy and past the active range of a
spreadsheet. So when I highlight a range, I want code that extracts
Sheet1!A1:A46, copies it to the clipboard. Assuming the code looks like this
for the string.

ActiveRange.Parent.Name & "!" & ActiveRange.Address

How do I create the right click option AND where do I put the code (personal
workbook!).

Thanks

EM