Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
If you want to enable or disable Trust access to Visual Basic Project in Office apps, such as Word, Excel, PowerPoint, etc., you can do so with the help of the in-built option, Local Group Policy ...