Paste Value Toolbar Icon

S

Steven

Can you call the PasteValue Toolbar Icon in a macro to execute.

Bottom line I am trying to Paste Value and still be able to Undo if needed.

Thank you,

Steven
 
P

Peter T

Nice idea but I don't think that's going to work, the Undo I mean. But have
a go -
(one of the toolbars must include the PasteValues button, customize toolbars
if necessary)

Dim cbt As CommandBarButton
Set cbt = CommandBars.FindControl(ID:=370) ' PasteValues

If cbt.Enabled Then
cbt.Execute
End If

Regards
Peter T
 
Top