Dialog box on right-click

[straubja]

I am trying to figure out how to replicate the code for a locked spreadsheet
which is used for problem solving. When you left-click on the cell, it
merely selects the contents, but if you right-click it, a rectangular box
with a set of options with small icons appears beside the cursor. The user
can then choose one of the options and then perform whatever macro one
wishes.

Does anyone know how this is done?

 

[Albert D. Kallal]

I am trying to figure out how to replicate the code for a locked
spreadsheet
which is used for problem solving. When you left-click on the cell, it
merely selects the contents, but if you right-click it, a rectangular box
with a set of options with small icons appears beside the cursor. The
user
can then choose one of the options and then perform whatever macro one
wishes.

Does anyone know how this is done?

Are you talking about in ms-access?

if you using a pre-2007 version, then you can simple create a custom menu
that then becomes a right click context menu. Any option in that menu can
then simple run some vba code.

here is some starting info:

http://office.microsoft.com/en-ca/assistance/HP051890051033.aspx

You want to look at the part called "custom shortcut menu" (this is a right
click menu).

 

[straubja]

Sorry, I goofed. I was supposed to put this in the Excel 2003 category.