new Excel shortcut causing issues with enabling LICSS in workbook

[Ryan Cammarota]

Hi,

I have been using the LICSS plugin with excel for a while now and I find it extremely useful, so thanks so much, Kevin, to begin with!  Recently, as I have been trying to get it working on my collaborators' computers, we have encountered a rather annoying error with the latest version of Microsoft Excel.  Apparently, the keyboard shortcuts in Excel have been changed such that ctrl + E now will automatically attempt to flash fill cells, which interferes with the shortcut for enabling the LICSS plugin in the Excel workbook.  As far as I can tell, the latest version of Excel has inexplicably removed the capability to change keyboard shortcuts, as my first thought was to simply change the flash fill shortcut to something else.  Is there a simple way to change the shortcut for enabling the plugin in the workbook for LICSS that I can change myself to allow it to work for users with newer versions of Excel?  Or would that require more complex re-working than I am envisioning?

Thanks so much for any help that anyone can provide!

Ryan Cammarota  

[Kevin Lawson]

Hi Ryan

Firstly, sorry for the slow reply as GMail has only just notified me of this post for some reason. Now, unfortunately, I don't have access to any of the recent versions of Microsoft Excel so I can't try out what I am about to suggest but I think I can point you in the right direction.

The macro that <Ctrl-E> is supposed to run is called lSetup. Now, by default, you can't see this because the code is hidden in the xla file. However if you display the box to view/run macros (in my version of Excel via the Developer ribbon) you can just type lsetup or lSetup and the option to run the macro is no longer greyed-out and it runs fine. If you prefer to define a new shortcut key for the macro you can do so by first selecting <Ctrl Shift Y>. This should toggle display of the xla file. Now, when you view the macros you should see all the macros available from the xla file and you can select lSetup, then Options and change the shortcut key. Finally select <Ctrl Shift Y> again to re-hide the xla file. When you quit Excel, you should get an option to save LICSS3.3.xla and you should respond 'Yes'

Do please tell me how you get on. If <Ctrl Shift Y> fails to work for any reason you can control the visibility of the xla file yourself by going to the VBA view (with <Alt F11>), selecting LICSSV3-ThisWorkbook and then View-Properties Window and changing the IsAddin value to false. Put it back again to true when you have assigned a new shortcut key.

Best wishes

Kevin

--

---
You received this message because you are subscribed to the Google Groups "LICSS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to licss-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/licss-users/6316a4ae-03cb-4ac4-bf7e-9c3d7c1ad6d5n%40googlegroups.com.

[Ryan Cammarota]

Thanks so much, Kevin!   I will let you know how it works for my collaborator who was having this issue.

-Ryan