Special Paste Dialogue Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 16 Oct 2006 23:01 GMT

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

Reply to this Message

RagDyer - 16 Oct 2006 23:20 GMT

It's on my "right click" menu!

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>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
[quoted text clipped - 3 lines]
> Thanks,
> Martin

Reply to this Message

Gord Dibben - 16 Oct 2006 23:33 GMT

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

>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
[quoted text clipped - 3 lines]
>Thanks,
>Martin

Reply to this Message

Martin - 17 Oct 2006 20:08 GMT

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

Martin.

> It should be on your right-click menu.
>
[quoted text clipped - 26 lines]
> >Thanks,
> >Martin

Reply to this Message

Gord Dibben - 17 Oct 2006 21:03 GMT

Thanks for the feedback.

Gord

>The ALT + F11 VB suggestion fixed the problem. Thanks. Thanks very,
>very much.
[quoted text clipped - 30 lines]
>> >Thanks,
>> >Martin

Gord Dibben MS Excel MVP

Reply to this Message