When I right click the mouse button there is no option for hyerlink. I use
to have it, how and why would this go away and how do I get it back?

Gone completely or just grayed out and not available?

Grayed out could be that the workbook is shared.

Or that the sheet is protected.

If gone completely...................

You can reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Enabled = True

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 10:19:01 -0800, Debtazmel
wrote:

When I right click the mouse button there is no option for hyerlink. I use
to have it, how and why would this go away and how do I get it back?

Gord Dibben MS Excel MVP