Hyperlink Option on Right-click short-cut menu gone?

[EagleOne]

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

 

[Ron de Bruin]

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

 

[EagleOne]

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]

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

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

 

[Dave Peterson]

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

 

[EagleOne]

That is why both of you are MVP's!

That was the issue.

EagleOne

 

[EagleOne]

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.


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

 

[Dave Peterson]

Good catch.

Thanks for posting back.

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.

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

 

[EagleOne]

Any way I can give back for what I have received.

 

[Dave Peterson]

I use page break preview very infrequently--maybe to adjust page breaks, then
back to normal. I know I often forget that the rightclick menus are different
in this view.

So I'm glad you reminded me--now all it has to do is stick somewhere in my
memory!

(I'm gonna guess that Ron is suffering the same problem <vbg>.)

 

[Ron de Bruin]

Good catch.

Yes