Software

Ask something
Discussion Locked

Macros for Excel

0 helpful
1 reply

by cholt2064

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by tonysjunkmailbox

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.

This discussion is closed to new replies.