Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link problem | Excel Worksheet Functions | |||
Excel: Blank Screen Stuck in Wierd Print_Area mode | Excel Discussion (Misc queries) | |||
Problem with link | Excel Worksheet Functions | |||
protect print_area? | Excel Programming | |||
Print Ranges when Print_Area not set | Excel Programming |