Use proper syntax in CustomUI.xmlįor testing purposes, I’ve just created one sub in a module: Sub test_only()Ĭlicking on the newly created ribbon item (to start the “test_only” macro, we’ll get an error message.Īdd ‘ control As IRibbonControl‘ as an argument to your subroutine. Just close Excel and re-open it, the add-in and the custom ribbons will appear.
To Unblock the File, please follow the steps below:
If the Trusted location method does not help, we try to figure something out. This folder is not trusted by default so you have to add it to the Trusted Locations list. Tip: You find the default AddIns folder under the following path:Ĭ:\Users\ \AppData\Roaming\Microsoft\AddIns Click the Go button while Excel Add-Ins is selected. Click the “Subfolders of this location are also trusted” checkbox if you are using subfolders. Choose FileOptions to open the Excel Options dialog box and then click the Add-Ins tab or press Alt+FTAA.Jump to the folder that contains the add-in.Open the Trusted Locations menu and use the following path: File > Options > Trust Center > Trust Center Settings > Trusted Locations. How to add a folder to the Trusted Locations list in Excel?
0 kommentar(er)
