View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Hyperlink Option on Right-click short-cut menu gone?

Good catch.

Yes



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dave Peterson" wrote in message ...
Good catch.

Thanks for posting back.

EagleOne wrote:

If your Hyperlink Option on Right-click short-cut menu appears to be
gone, Check to see if the worksheet is in View Page Break Preview.
If so, Set View Normal and re-check to see if your Short-cut options
are back.

************************************************** ********************************

Ron de Bruin wrote:
Hi EagleOne

Is the whole menu gone or only the Hyperlink options ?

Try this
Alt -F11 (open the VBA editor)
Ctrl-g (open immediate window)
Paste this code line
Application.CommandBars("Cell").Reset

And press Enter


Alt-q to go back to Excel



--
Regards Ron de Bruin
http://www.rondebruin.nl



"EagleOne" wrote in message ups.com...
2003

The file is not protected in any way(sheet, wks or allow-edit ranges).

Previously, when I right-clicked a cell I would get an option to add a
hyperlink.

If there already was a hyperlink I would also have an option to Edit
it. That is also gone.

I have closed down Excel and re-booted.

Any help appreciated!

EagleOne


--

Dave Peterson