View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
EagleOne EagleOne is offline
external usenet poster
 
Posts: 68
Default Hyperlink Option on Right-click short-cut menu gone?

Ron thanks for your time and thoughts,

This is interesting. First, I did attempt the reset but to no avail.

In the process, I "accidently" right clicked on a blank sheet and guess
what?

On that sheet all was there, including my PUP ehanced menu items.

I then re-loaded the file 13MB XL file (which was loaded when I first
had the problem) and the problem came back.

Dumped XL; repeated the process with the same results.

Therefore, could filesize (loaded RAM) cause XL features to be limited?

TIA EagleOne


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