right click button customization?

[Lori]

Is there a way to customize the list of commands that
pops up when you right click. a few days ago I'm sure
that edit and remove hyperlink were options when I right
clicked over a cell that had a hyperlink. now I do not
have that option. is there a way to get it back.
thatks - L

 

[David McRitchie]

Hi Lori,

You should see most of the following (as applicable) on the right-click
popup menu, and most show icons besides the wording. (Excel 2002)
Cut
Copy
Paste
Paste Special...
Insert...
Delete...
Clear Contents
Insert Comment
Delete Comment
Show Comment
Format Cells...
Pick From List...
Hyperlink...

Try the following in a macro.
Application.CommandBars("Cell").Reset

If you were working on a right-click Event macro you would have included.
Cancel = True 'prevents normal Right-Click menu from appearing
in which case you would not see any normal right-click menues
for that specific worksheet.