Special Paste Dialogue Box

[Martin]

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

 

[RagDyer]

It's on my "right click" menu!

 

[Gord Dibben]

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

 

[Martin]

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

Martin.

 

[Gord Dibben]

Thanks for the feedback.

Gord

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

Martin.

Gord Dibben MS Excel MVP