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.

Application.EnableCancelKey = wdCancelDisabled 

Include this line at the end of the macro.

Application.EnableCancelKey = wdCancelInterrupt 

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 ?

-2147024809 : The item with the specified name wasn't found  

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