Disable paste special attributes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top