Reclaiming shortcut keys

[Jason Olchovy]

Kevin,

This addin continues to be very useful as I can see structures while I am using my sheets.  One of the shortcuts I use all the time in Excel is ctrl-r for copy cell right.  Unfortunately that is now mapped to DisplayRowStructure.  Even after I commented out lines in SSS>>AssociateMacros related to keyboard shortcuts and added resets to ctrl-r I am still unable to use my ctrl-r for copy cell right.  As a novice with VBA, it's unclear, without disabling LICSS, how to re-claim my shortcut key.  How would I go about resetting my ctrl-r?

Thanks!

Jason

[Kevin Lawson]

Hi Jason

Open Excel with a blank workbook. Select <Ctrl Y> (this toggles the IsAddIn Property of the LICSS add-in to false). Select View-Macros and choose the DisplayRowStructure macro. Under 'Options', delete or reset the shortcut key. Cancel out of the menu system back to the LICSS add-in worksheet (LICSS-Enable). Select <Ctrl Y> again (the LICSS-Enable sheet should disappear and you should see your blank workbook again). Quit Excel but, when prompted to save LICSSv3.0.xla, do so. You can change any other key-associations in the same way. If you change the Ctrl Y key association by the way, you can achieve the same effect by toggling the IsAddIn property of 'ThisWorkbook' for LICSSv3.0.xla in the main VBA editor (<Alt F11> from Excel). [if y]ou don't see a properties window, select F4 to display it

Best wishes

Kevin

[Jason Olchovy]

Thanks again Kevin!