Ignore shift on open

[tiredofit]

I want to add a control so depsite the user holding down the shift ket, macros still run (assuming macros are enabled of course)!


This article indeed does this:

http://pixcels.nl/disable-shift-key-on-open/

However it mentions this code needs to be added in the Ribbon module:

Sub customUI******(ribbon As IRibbonUI)

    ThisWorkbook.CheckShiftOnOpen

End Sub

Is that the module call RibbonX_Code in FUNCRES.XLAM?


I added the code there saved the workbook, closed it down, opened it but that code is not there anymore.


How can I "make it travel" with my workbook?


Thanks

 

[jkpieterse]

The customUI code is a callback which goes into any "normal"module (Insert, Module) of the file to which you also need to add RibbonX XML code using a tool called the OfficeUIEditor.

 

[tiredofit]

Thanks