lost insert hyperlink option on right click

G

gigi6d

I used to have an option to insert hyperlink on my right click in excel. It
is gone now, can I put it back in? I know I can use the tool bar, but I
liked having it on my mouse, I use it alot.
 
S

Shane Devenshire

Hi,

Is it gone or just grayed out?

Make sure you are not "in" the cell, not in the Edit Mode. You also don't
get the command at all if you right click a row or column.

The command can be removed via vba, but I doubt that is your problem.

You can also press Ctrl+K, the Add or Edit Hyperlink shortcut key.
 
G

Gord Dibben

Alt + F11 to open VBE.

View>Immediate Window.

Copy this into that window and hit ENTER key.

Application.CommandBars("Cell").reset


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top