Thanks for your reply.On 2002-04-29 15:40, Mr Nick wrote:
Do you really need to keep the single option?
The easiest way would be to remove Paste Special completely:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Cell").Reset
End Sub
Private Sub Workbook_Open()
Application.CommandBars("Cell").Controls("Paste Special...").Delete
End Sub
On 2002-04-29 15:29, kriccio wrote:
Can anyone tell me what the macro codes would be to disable all of the items on the paste special menu except the Values selection. When users cut and paste they overwrite my conditional formats.