Link to home
Start Free TrialLog in
Avatar of PeterWhitts
PeterWhittsFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

Peter,

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
Avatar of PeterWhitts

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
ASKER CERTIFIED SOLUTION
Avatar of Dave
Dave
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good little product running code...many thanks