I am trying to add xl2bb.xlam from another forum so that I am able to add a mini spreadsheet to my posts about Excel.
The version of Excel I am using is MSOffice Pro Plus 2021 version 2302 (Build 16130.20332) as of 27MAR2023.
Windows Build/Version Version 21H2 (OS Build 22000.1696) as of 27MAR2023
1 Right-click on the file, select Properties, it should open at the General tab. If there is an Unblock checkbox near the bottom right corner, click in it then click on the OK button.2 Move the file somewhere under your control. I put script files & macro-enabled files, such as Excel add-ins, in sub-folders within a C:\Tools protected folder created for the purpose - see Set up my Tools folder ditty - TenForums
3 In Excel, File menu, Options, Trust centre, Trust centre settings, Trusted locations, Add new location - add the path to your C:\Tools-equivalent folder and set the checkbox for also trusting its subfolders, OK, OK, OK.
All the best,
Denis
Thanks for this, I will work on it and get back to you. It seems every time I go down a rabbit hole, 6 more cascade.1 Right-click on the file, select Properties, it should open at the General tab. If there is an Unblock checkbox near the bottom right corner, click in it then click on the OK button.2 Move the file somewhere under your control. I put script files & macro-enabled files, such as Excel add-ins, in sub-folders within a C:\Tools protected folder created for the purpose - see Set up my Tools folder ditty - TenForums
3 In Excel, File menu, Options, Trust centre, Trust centre settings, Trusted locations, Add new location - add the path to your C:\Tools-equivalent folder and set the checkbox for also trusting its subfolders, OK, OK, OK.
All the best,
Denis
And I have just been thinking about your Excel forms problem in ElevenForum.
Is that file in a Trusted location? It ought to be as it's using an ActiveX control.
Thanks for the rep,
Denis
And welcome to TenForums.
It's really worth making time to browse through the Tutorial index - there's a shortcut to it at the top of every page.- At the foot of the Tutorial index is a shortcut to download it as a spreadsheet.- Tutorials are also listed by category at Tutorials - there's also a shortcut to that at the top of every page.
- I download a new copy each month.
- By downloading it as a spreadsheet I can benefit from Excel's excellent filtering capabilities when I search for topics of interest.
- Both tutorial lists are searchable.
- You can also search for TenForumsTutorials in many general search engines, such as Google, by adding site:tenforums.com/tutorials after your search term. For example,
taskbar toolbars site:tenforums.com/tutorials
You can search TenForums using the search box in the top-right corner of all TenForums webpages or using Advanced Search - TenForums
- You can also search TenForums threads in many general search engines, such as Google, by adding site:tenforums.com after your search term. For example,
Search for drivers by HardwareID site:tenforums.com
- [This is what the search box in the top-right corner of TenForums webpages does automatically]
Quote
