Right click - Paste Special Clear Formatting

[projectaero]

Hello.
Basically we have a excel spreadsheet that is locked by the company which blocks you from ctr v from the excel document to any other document, but you can right click paste.

What i am wanting to know is there a macro you can set up that clears formatting when right clicking paste.

Thanks

[SamT]

Right click, Paste Special.

[Bob Phillips]

Add this to ThisWorkbook to setup the menu



Private Sub Workbook_Open()
With Application.CommandBars("cell").Controls.Add(Type:=msoControlButton, temporary:=True)

.Caption = "Clear Formatting"
.OnAction = "ClearFormatting"
End With
End Sub


And this to a standard module



Public Sub ClearFormatting()
Selection.ClearFormats
End Sub

[projectaero]

Is there a way to bypass the:

Paste Special box:

HTML
Unicode Text
Text