ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Removing a hyperlink when right click doesn't open shortcuts? (https://www.excelbanter.com/excel-worksheet-functions/113319-removing-hyperlink-when-right-click-doesnt-open-shortcuts.html)

[email protected]

Removing a hyperlink when right click doesn't open shortcuts?
 
Can someone help me with this? It is a Train and Assess IT program question
on a module. For whatever reason, the right click does not bring the
shortcut menu down.


Thanks!

Gary''s Student

Removing a hyperlink when right click doesn't open shortcuts?
 
If right-click does not work:

1. move to the cell with the arrow keys
2. in the formula bar, insert a single quote (apostrophe) before the link
--
Gary's Student


" wrote:

Can someone help me with this? It is a Train and Assess IT program question
on a module. For whatever reason, the right click does not bring the
shortcut menu down.


Thanks!


Gord Dibben

Removing a hyperlink when right click doesn't open shortcuts?
 
Does the right-click menu drop down when other cells are selected or just this
one cell?

You may have to reset the r-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 Sat, 7 Oct 2006 13:46:02 -0700, Gary''s Student
wrote:

If right-click does not work:

1. move to the cell with the arrow keys
2. in the formula bar, insert a single quote (apostrophe) before the link
--
Gary's Student


" wrote:

Can someone help me with this? It is a Train and Assess IT program question
on a module. For whatever reason, the right click does not bring the
shortcut menu down.


Thanks!



[email protected]

Removing a hyperlink when right click doesn't open shortcuts?
 
Thank you so much! By using the arrows, I was able to complete the exercise
successfully. I REALLY appreciate the help!!!!


Steve

" wrote:

Can someone help me with this? It is a Train and Assess IT program question
on a module. For whatever reason, the right click does not bring the
shortcut menu down.


Thanks!



All times are GMT +1. The time now is 09:02 AM.

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