Global macros


show more Global macros provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Global macros

The trouble with the macros that we've created so far is that we've been saving them in the workbook that's currently open, and this might be desirable if you have a macro that's specific to one workbook that you're only going to use within the sheets in that workbook and you want to pass it around. That's fine. If you want a macro that's going to be globally available, you need to save it a little differently. Let's go ahead and re-create our titles macro again, and this time we'll save it in our personal workbook. Let's go up to QUARTERLY SALES. This is a title we've already added. Select a range and this time when we record our macro we're going to call this Titles3, set a global shortcut for t, and again this is something that was in a previous workbook, so it's no longer a conflict, and we're going to store it this time instead of This Workbook in a Personal Macro Workbook. This Personal Macro Workbook exists at a higher leve...

Global macros
Video duration: 3m 31s 4h 8m Beginner

Viewers:

Global macros provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...