Delete Link in Unbound OLE control

[Philly44]

I have an Unbound OLE control on a form that I use to display a named region on an Excel spreadsheet. The problem I'm having is that it won't remove the link to the specified region. I have quite a few spreadsheets that I will need to access with about 300 different named regions. I don't want to have to create 300 different forms. If anyone can tell me how to DELETE this link I would be forever in your debt.

Thanx in advance

 

[ide]

'...
Me.OLEUnbound4.Action = acOLEClose
Me.OLEUnbound4.Action = acOLECreateLink
Me.OLEUnbound4.SourceDoc = "D:\TEMP\Book3.xls"
'...

I have just one idea now, how to hide the message "The document you are opening contains macros. Some macros may contain..." appeared; in Excel set the macro protection to "Low level"

ide

 

[Philly44]

Sorry I should have posted yesterday, I fixed it. For some reason there was some code way over to the right that I hadn't realized was there. Once I got rid of that the problem went away