| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Option on Right-click short-cut menu gone?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
That is why both of you are MVP's!
That was the issue. EagleOne Dave Peterson wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
Any way I can give back for what I have received.
Dave Peterson wrote: 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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink Option on Right-click short-cut menu gone?
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.) EagleOne wrote: Any way I can give back for what I have received. Dave Peterson wrote: 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 -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Right click in cell menu options | Excel Discussion (Misc queries) | |||
| Right click menu in Office products | Excel Discussion (Misc queries) | |||
| Undoing LINKS in Excel 2000 | New Users to Excel | |||
| adding an option to the right click menu | Excel Discussion (Misc queries) | |||
| adding an option in the right click menu | Excel Discussion (Misc queries) | |||
Hybrid Mode
