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) How can I prevent a user from interrupting a macro with (Ctrl + Break) ?
Include this line at the start of the macro.

Include this line at the end of the macro.

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

4) Why am I getting this error message ?

The most common reasons are missing bookmarks, fields, styles, content controls, document properties.

5) Is it really necessary to insert an image, inside a table, inside a textbox ?
The layout engine in Word can be unpredictable, so using this combination is recommended.
The textbox - isolates the whole block from the main document flow
The table - provides a rigid internal grid
The image - the actual content