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