Try this to see if you can find it:

Insert a new (temporary) userform into your workbook's project.

Then look at tools|references and see if you see something new checked.

Then remove the Userform.

mtatlow wrote:

When I try and run this code I receive a User-defined type not defined ERROR
how do I set MyDataObj in Excel2003

"ste mac" wrote:

Hi, try this, its one of Chips.. l use it all the time..

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub

seeya ste


--

Dave Peterson