It is easy to enable the checkbox in the options screen. The option can also be set via a registry entry (or two). To register a change in the registry, Excel must be restarted, but ALSO it is important to note that when Excel exits, it resets this flag. Excel cannot be running therefore. This […]
This article is simply a super great place to find links to the most used articles imageMso codes for customUI images [MS-CUSTOMUI]: Custom UI XML Markup Specification Absolute Path example of onAction onAction=”‘L:\Directory1\Directory2\Spreadsheet name.xlam\’!MyFavFunctionInExcelsName” and then you need to add a handler called MyFavFunctionInExcelsName(control As iRibbonControl)
There are some pretty cool “on the fly” programmatic things we can do with the VBA references like deleting “MISSING” references (which break code that is referenced UNDER these missing references- that is why they need to be fixed). But to do so requires that the user checks the box ‘Trust access to the VBA […]
Here’s a couple links that explain how to unzip and modify the OpenXML file hierarchy of .xlsx and .xlsm files and how to create custom ribbonUI. This should make it possible to access and modify the customUI ribbon via customXMLParts at runtime. Opening and modifying excel files as zips: https://www.jkp-ads.com/articles/excel2007fileformat02.asp VBA customUI editor: https://yoursumbuddy.com/ribbon-customui-xml-editor/
First, we need to learn where the Cadworx settings are stored.If we can manipulate the constants with variable manipulation – then we have moved one step closer to not needing a mouse. Placing components seems to be quite easy without a mouse. get a list of system variables (nope – not it) spitting command output […]
I am keeping it simple – this is reference that helps me explain things for myself and for my customers. Situation: why do I need RAID 5 when we have 2 NAS’s – it already has redundancy/backup. RAID 5 is not being used for redundancy – it is used to lower the overall cost of […]
I use cpuboss alot but lately it doesn’t deliver or have as many CPU’s I have been looking for lately – but its google ranking is killer – so it is at the top. I am looking up a new QNAP for a client and wanted to compare it with the current QNAP he has. […]
https://www.guidingtech.com/change-itunes-backup-location-windows-10/
Now GoDaddy offers experts to install your SSL for you and do audits etc. This means things are getting serious on the net and the news on the radio supports that. But I thought, why is there so much difficulty in installing SSL? Well, it isn’t that difficult but there are a lot of things […]
There is a difference between closing the window when things went well (usually a button at the lower or upper right) and when we just close the dialog (the x in the upper corner). When things went well and we close the window we should auto-refresh https://sharepoint.stackexchange.com/questions/202829/how-to-refresh-page-after-closing-dialog-form-sharepoint-2013 The google search it came from: https://www.google.com/search?rls=com.microsoft:en-US:IE-Address&q=SP.UI.ModalDialog.showModalDialog+auto+refresh&spell=1&sa=X&ved=0ahUKEwjmsoLB6qHdAhVk3IMKHe64DXQQBQgkKAA&biw=1920&bih=934 […]