View Single Post
  #10   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?

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