copy code into all open wkbks

  • Thread starter Thread starter nkeiru
  • Start date Start date
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
 
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.
 
Could be done, but more details would be in order.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Stopping other wkbks sharing code 15
Merge Multiple workbook sheets into one workbook 0
Copying linked sheet 2
Excel Move or Copy Stopped Working? 0
unable to view all open excel worksheet from window 2
Move/Copy Worksheet with Macros 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top