Break Links in Worksheet but keep data

I have some code on a workbook that deletes all Conditional Formatting but keeps all the colours imposed by all the rules.

On another workbook I would like to do the same, but for External Links and supplied data.

I have a Template Worksheet that is copied and made into the current week Briefing Sheet. At the end of the week I am required to save this worksheet as a PDF and email it to all staff, but before sending it I want to be able to break all of the links to external data for that specific worksheet so that if it is opened again in the future the data will be relevant for the week it was archived.

I plan to put a Macro Button on my Template Sheet so that when it is copied the Macro will be in place for the end of the week, but i am unable to find any usable code to break the links but keep the data.

Anyone able to help?

There are different types of links. Have you tried the breaklinks method?

https://learn.microsoft.com/en-us/of...book.breaklink

Hi BM

i will have a look at that now.

In the meantime I have tried recording a macro with the following code

Please Login or Register  to view this content.

If I add in "ActiveSheet.Unprotect Password:="SSD84006"" before the End Sub it throws up all sorts of errors.