hyperlinks

D

Debtazmel

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?
 
G

Gord Dibben

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 View>Immediate 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

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?
Click to expand...

Gord Dibben MS Excel MVP
 
Top