Thanks. Will get on it ASAP and will post when finished.

EM

"Ron de Bruin" wrote:

Hi ExcelMonkey

You can create a add-in
http://www.jkp-ads.com/Articles/DistributeMacro00.htm


You can make a new option in the Cell menu

http://support.microsoft.com/default...02&Product=xlw
How to customize menus and menu bars in Excel


http://www.j-walk.com/ss/excel/tips/tip53.htm
Creating Custom Menus (John Walkenbach) TIP


http://www.erlandsendata.no/english/...oadcommandbars
Ole P. Erlandsen's Web Site (Example workbooks)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ExcelMonkey" wrote in message ...
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