What is the correct way to move Excel files from Win 10 to Win 11?

[JenniferMurphy]

I bought a new Win 11 laptop and am in the process of moving everything over from my old Win 10 laptop. I copied the entire C-disk to both a thumb drive and a USB drive. I also used Acronis to take a full disk image backup that I have on another USB drive.

I have a lot of xlsm workbooks with modules containing macros and UDFs that are specific to that workbook. I was able to get them working by setting the Enable VBA macros... option in the Trust Center.

I did see the warning about possible malicious code and the option about disabling macros except digitally signed macros.

Question #1: Is there a way I can get my add-in digitally signed?

I have a fairly large add-in module with dozens (possibly hundreds) of macros and UDFs that I have written over the years. I also have other add-ins such as xl2bb.

Question #2: Where is the correct place to put these modules? Are they all xlam files?

I see that xl2bb is here: C:\Users\User\AppData\Roaming\Microsoft\AddIns. Is that where I should put my add-ins?

Thanks

 

[RoryA]

For digital signatures: Show trust by adding a digital signature - Microsoft Support

Yes, add-ins should generally go into that folder.