all open workbooks

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
F

Filips Benoit

Dear All,

I have created a marcro and set it for 'All open Workbooks'.
When I open another xls-file on the same computer the macro is not visible
in the list.

What should I do to create a marcro that is usable for all workbooks on my
computer but the code should not hang on a particular xls-file.

Thanks,

Filip
 
Filips
If you don't already have one, create a Personal.xls file. This is a
hidden file that is opened automatically whenever Excel runs. Place your
macro in that file and that macro will be available to any open file. Post
back if you need help with this. HTH Otto
 

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

Share and protect 1
VBA insert column with two workbooks open 1
Excel crashes when I try to save workbook 4
update all hyperlinks to another drive 1
Excel 2003 - Keep a Macro Running While the Workbook is Open 4
Run code from another workbook 7
Programatic access to VB-editor not trusted 2
Error Opening Workbook 3

Back
Top