PeterWhitts
asked on
VBA to Remove All Links to Other Workbooks in Excel 2007
Can an expert suggest vba code that will remove entirely all links to other workbooks be they named ranges or individual cell formulas.
Many thanks
Many thanks
ASKER
Not in need of removing hyperlinks....just all links to other workbooks...thanks anyway...but I need vba
I apologized. I misread your question. My fault.
I agree that VBA offers best solution, but there are features in Excel that you may use to make what you want to happen. In your scenario, you may select all cells that contain all the links then Copy. You then use the Paste Special Values Only.
Sincerely,
Ed
I agree that VBA offers best solution, but there are features in Excel that you may use to make what you want to happen. In your scenario, you may select all cells that contain all the links then Copy. You then use the Paste Special Values Only.
Sincerely,
Ed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good little product running code...many thanks
How about removing it not using VBA as the link below? Though, out of the question I still posted the link for you might consider this option.
http://www.ehow.com/how_2322386_remove-hyperlinks-microsoft-excel.html
Sincerely,
Ed