View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hyperlink Option on Right-click short-cut menu gone?

Just to add to Ron's response...

close excel and reopen it
(use Ron's tip to reset the cell menu if you have to).

Now, go to tools|macro|security|security level and set it for medium.

Open your 13MB file, but say no to allow macros.

If the rightclick menu still shows up, there's a good chance that Ron's guess
about the code to change the menu is spot on.

(don't forget to change that security setting back to what you really want.)

Ron de Bruin wrote:

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

No

Is there code in the big file that change the menu's ?

Is the whole menu gone or only the Hyperlink options ?


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

"EagleOne" wrote in message ups.com...
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



--

Dave Peterson