User FAQs

If you have a question, please send it to us.

1) How do you assign a shortcut key to a macro ?
File > Options > Customise Ribbon. Keyboard Shortcuts, Customise
Choose Macros in the left drop-down. Select the macro
Enter the shortcut key and press Assign

2) Can you use VBA to read from a .xlsx file saved in a SharePoint document library ?