ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lost insert hyperlink option on right click (https://www.excelbanter.com/excel-discussion-misc-queries/224360-lost-insert-hyperlink-option-right-click.html)

gigi6d

lost insert hyperlink option on right click
 
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.

Shane Devenshire

lost insert hyperlink option on right click
 
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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"gigi6d" wrote:

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.


Gord Dibben

lost insert hyperlink option on right click
 
Alt + F11 to open VBE.

ViewImmediate Window.

Copy this into that window and hit ENTER key.

Application.CommandBars("Cell").reset


Gord Dibben MS Excel MVP

On Sun, 15 Mar 2009 08:53:02 -0700, gigi6d
wrote:

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.




All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com