Make macro available in all workbooks

  • Thread starter Thread starter Vanessa Cassidy
  • Start date Start date
V

Vanessa Cassidy

Hey there

I have created a macro to run on a particular csv file. The contents of
this file are the result of a report ran from another application. I need
the macro to be available to all workbooks, so that when the macro is to be
run on the file, it will always be available.

I have tried selecting - Macros in "All Open Workbooks", but this does not
seem to retain the macro when a different file has been opened

Can any 1 help?

Cass
 
Hi
normally saving your file in the personal.xls should be sufficient. Aother
option would be to create an addin for this macro and install this addin
 
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

Macro available in all workbooks 8
saving macro from workbook to Personal Macro Workbook 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel TWO Instances of Excel One watching Other 3
Multiple Workbooks using same macro 4
Macros Available without hiding 'personal.xls'? 3
Run Macros in a Password-protected workbook? 1
WorkbookBeforeSave Problem 3

Back
Top