View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 17
Default Print_Area link problem

Hi,

I'm having a problem with deleting a link using a macro. The link is a
"Print_Area" link to another workbook and I've used the code
"ActiveWorkbook.Names("Print_Area").Delete", but this doesn't seem to remove
the link.
But if I go to "Insert" menu of the workbook, select "Name - Define" select
the "Print_Area" name and delete it, this works, why?

I've also tried to delete all links from the workbook using the following
code:-

Dim nm As Object
For Each nm In ActiveWorkbook.Names
nm.Delete
Next

This seems to delete all links except for the "Print_Area"

Can someone please help,
Thanks
Best regards,
Scott