copy code into all open wkbks

N

nkeiru

How do I copy a code that I want to use and store it
in "all open workbooks', instead of on the open worksheet
only
 
D

Dave Peterson

You can put it in another workbook and then just make sure that this other
workbook is open when you need the code.

Lots of people who need this functionality, put their code into a workbook named
personal.xls and then save that personal.xls into their XLStart folder.

By placing the personal.xls workbook there, it's opened each time you start
excel.
 
Top