Code-Vault | Some Secrets are Meant to be

I wonder if you could help me with the following problem.
I have a huge document that contains many duplicate paragraphs. I've found a macro on the Internet that can find them all and delete them:

I have hacked together code (from a couple of sources, references at the bottom) that programmatically will take worksheet scoped named ranges and convert them to workbook named ranges. However my code only works for some named ranges and not others, and I can't figure out why.

The reason I'm having to do this is because I had to delete two tabs (one of the tabs containing _T and the other _X) from the original source and copy in the duplicates of these tabs from another source. This leaves me with workbook scoped named ranges of #REF!#REF and worksheet named ranges that have the ranges I want but I need them Workbook scoped.

See code below

If I run this code looking for "_T", it works perfectly. All workbook named ranges starting with _T that were #REF!#REF now have the correct range and their counterpart worksheet named ranges are deleted. HOWEVER, if I run this looking for "_X", the workbook named range goes unchanged. I'm stumped. I have even tried a different approach where I manually delete all of the current workbook named ranges starting with _X, and then programmatically try to Add them using ActiveWorkbook.Names.Add Name:=newNm,RefersTo:=nm.RefersTo which also does nothing (doesn't even add a new record).

Thanks in advance for the help.

I am losing my mind over this and I know it is much more simple than I am making it.

I am looking to simply replace multiple occurrences of text with a hyperlink that is masked by the same text.

Scenario: We are moving to Google Classroom due to Covid-19 and we are thinking ahead to September. I can export pupils timetables in bulk to excel as HTML files (lets call this file timetables). I have a separate file with a list of all class names and the links for the Google Classrooms (lets call this one classes). I have copied these values into 'Sheet1' of the timetable file for the code below.

If I can use the classes list to search for all occurrences of the classes in the timetables then replace them with the hyperlink to the google classroom but I want it to appear as the classname.

This is an image of the timetable file. This is one timetable but the file continues the same pattern for different pupils

This is an image of the classlist file. Imagine there were all classes listed and links were valid.

I have been trying this code that I found but cannot get a working hyperlink in the "replace" element.

I just ran into an even more annoying problem. Suddenly windows defender started to flag one of my excel files containing VBA macro code(on download from a browser) as being a virus. The specific virus being logged is:

Trojan:O97M/Foretype.A!ml

Googling it reveals the following information:

O97M.Downloader is a generic detection for Microsoft Office macros that download other threats. They are usually contained in other Microsoft Office documents and may arrive on the compromised computer through attachments or after being downloaded from a website.

Great, so once windows defender detects it, it basically shreds the file, and when you attempt to open it, excel claims the file has "been corrupted". I would love to post my VBA file to http://www.virustotal.com however it contains tons of propriety VBA code that cannot be shared with the wider community. I wonder if there's a website that accomplishes the same thing with a different terms and conditions?

This has only started recently and has only affected a few users/clients. I'm not sure the distribution of clients who have this installed and what versions of windows defender they are running. I'm worried the impact of this will increase until a large number of our clients are affected. Even more troubling, often clients can download one version without issue, but when they download the file(identical VBA code) from a different source they encounter the issue, could the download source affect the files likelihood of being flagged?

Main Question

What causes a excel VBA file to be flagged as a "O97M" virus and how do I prevent it from being flagged?

Related Concerns

Should I sign my VBA Macro's, would that affect the virus detection likelihood?

Are they're other common practices that I could change that would affect the likelihood of false positives?

What is a "Trojan:O97M/Foretype.A!ml" exactly? The window page contains so little information it might as well not exists, Symantec is also pretty unhelpful, (maybe I'm massively uninformed here) is there a centralized repository for virus detection? I would imagine that people may not want to share that and it my differ by product, but I'd be interested in any information pertaining to this...

External Libraries

I'm also using the following external code:

https://gist.github.com/brucemcpherson/3414365/

https://www.thespreadsheetguru.com/the-code-vault/2014/4/23/loop-through-all-excel-files-in-a-given-folder

How to use VBA SaveAs without closing calling workbook?

I'm also using the following window functions:

I am trying to convert a large number of xls files to xlsx. I found some code here that I modified to SaveAs with a new format. However, some fraction of my files are corrupt and they cannot be opened. I would like to simply skip those files and so I added the lines indicated in the comments (prefaced with the word ADDED.

Every time I run the code I still end up with a run-time error with a message that the file cannot be opened (1004 Method Open of Object Workbooks failed). I use the debug button and the Set wb~ statement is highlighted. I have tried many variations of the use of colons (I have very little experience in VBA).

Let me be clear - I have the same result whether or not there is a colon after the NextFile.

I am trying to remove animation with the help of vbscript in powerpoint. But it should remove only from selected slide not from all slides

I have tried some code but it's removing from all the slides sharing below the sample code, can anyone please help me with the solution

Objective: in a table, allow users to select rows (the rows where the SELECTION is), press a short cut and delete those rows. No matter if they are filtered and the selection is in non contiguous ranges or not.

I have the code below I got from another site and modified it:

The problem varies, from runtime error 1004: can't move cells in a filtered range or table to delete method of class failed (or something, it happens less often than the first one)

I have found a vba script to find and replace words but the script replaces the words in the whole workbook, I would like it to replace the words only in a specific sheet. This is the code I have found.

I'm importing several sheets of data to another workbook and wanted a simple way of converting the strings that are numbers into numbers. So I found this code that did exactly what I wanted https://www.thespreadsheetguru.com/the-code-vault/2014/8/21/convert-numbers-stored-as-text

It ran fast and smoothly which was very appreciated, but when I started to work with the data I noticed a discrepancy. I found that two cells had converted into two completely different numbers. As of writing these are the only two I have found, but it is quite worrying if there could be more. An example is the string "1,225" became -611779. (Yes I'm using decimal commas)

For some reason it decided that these two "strings" of numbers was something completely different. Yet, the same numbers, in another sheet, had been correctly converted.

My question now is: is there some reason that these two (and perhaps more cells) could have caused the script to completely fail in converting these numbers correctly. Or is the code flawed?