Disable paste special attributes

[Hippy]

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

 

[Leith Ross]

Hello Hippy,

The Paste Special dialog doesn't expose any events, properties, or
methods through VBA. The dialog is launched by the built-in ID. Once
the dialog os up the only thing you can do is Click on a control.

Sincerely,
Leith Ross