Re: Special Paste Dialogue Box

The ALT + F11 VB suggestion fixed the problem. Thanks. Thanks very,
very much.

Martin.
Gord Dibben wrote:
It should be on your right-click menu.

If not, perhaps you need to reset that menu.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").Enabled = True

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

Also, In Tools>Customize>Commands>Edit is a Paste Special Icon that can be moved
to a Toolbar.


Gord Dibben MS Excel MVP

On 16 Oct 2006 15:01:44 -0700, "Martin" <metpx3c@xxxxxxxxxxx> wrote:

I use the Special Paste options frequently. Is there a simiple way to
open that dialogue box? Such as a hotkey combination or a way to add it
to the right-click (mouse) menu? It is a pain to always have to mouse
click "Edit" then "Special Paste..."

Thanks,
Martin

.

Relevant Pages

  • Re: Excel 2000 missing menu file, view, etc.
    ... Bar and enable or reset? ... ALT + F11 will open the Visual Basic Editor. ... Gord Dibben Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: 2 Gigs of RAM...
    ... I only upgraded for the RAW converter. ... decided there was some danger here so hit the reset button my machine. ... I've never had this sort of problem with a program before... ...
    (rec.photo.digital)
  • Re: Alt E no longer opens Edit menu
    ... It's probably too late now, but if you had hit the alt-e once more, then enter, ... simonc wrote: ... I reset the standard toolbar and now Alt E works ... Hit alt-e again and edit won't be depressed. ...
    (microsoft.public.excel.misc)
  • Re: Auto Stamp Date
    ... Alan, thanks so much for the help. ... I have found the Alt F11 but where do I ... and I make add, update or change informaiton in cells B1, C1 or D1 is it ...
    (microsoft.public.excel.misc)
  • Re: ATTN JMS: Humans build communities
    ... >>> It's juch a rich universe and so little of note was done with it... ... >> Hitting the reset button exemplifies all that is wrong in Trekland. ... >> Don't hit the reset button, and don't do another prequel series. ... > its history so as to constrain any future Trek both in terms of continuity ...
    (rec.arts.sf.tv.babylon5.moderated)