General discussion


Macros for Excel

By cholt2064 ·
I have written some Macros that are useful multiple times during a given day. I would like these Macros work all day without having to create a template which would increase the size of each file. Is there common area where I can save my scripts besides the modules on a given workbook?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Personal Macro Workbook

by tonysjunkmailbox In reply to Macros for Excel

Tell excel to record a macro and choose to store in Personal Macro Workbook. Excel then creates a hidden workbook you can put your macros in. This workbook is automatically loaded each time you open excel.
Very useful for those control key macros.

Related Discussions

Related Forums