I have a spreadsheet that I only want users to paste data using "paste
special - values". I have disabled the "paste" selection from all the menus
when the spreadsheet is active. I would like to disable all the
functions(features, radio buttons) inside the "paste special" box, except for
"values" , when it is displayed to the user so they do not have the option to
paste incorrectly.

I disabled the paste menu functions using:
Dim Ctrl As Office.CommandBarControl

For Each Ctrl In Application.CommandBars.FindControls(ID:=22)
Ctrl.Enabled = True
Next Ctrl

Is there a simular command that can only allow me to select "values" on the
"paste special" selection box?

Thanks