see Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm

You would need to use worksheet deactivate and worksheet activate
instead of workbook close and open for changes to the menu.

some additional help with event macros
http://www.mvps.org/dmcritchie/excel/event.htm

Kind of think it is overkill, and that application.inputbox
would have served the purpose
http://www.mvps.org/dmcritchie/excel/inputbox.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Matt" wrote in message ...
I would like to add a feature where a popup box appears when a user
right-mouse clicks on any cell in the range a1:a20. Two options should be
available when the right mouse button is depressed within that range. Option
1 will launch one macro and Option 2 will launch another.