Removing a hyperlink when right click doesn't open shortcuts?

[Guest]

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!

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

Thank you so much! By using the arrows, I was able to complete the exercise
successfully. I REALLY appreciate the help!!!!


Steve