How to enable macros in Excel If you are willing to accept the risk of enabling all macros in Excel, you can permanently enable them using the Trust Center. 1. Click "File" and then click "Options ...

You can show File Path on Title Bar in Excel and Word by creating and running a Macro - and even in Quick Access Toolbar too. This post explains the process in detail.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

Listing A includes the VBA command necessary to update all fields in the document. The demonstration Word .docm file contains this repurposed Save command (in its NewMacros module).