all open workbooks
 

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

all open workbooks
 

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
"Filips Benoit" wrote in message
...
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

all open workbooks
 

Thanks,

How stupid of me that i forgot this !

Filip

"Otto Moehrbach" wrote in message
...
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
"Filips Benoit" wrote in message
...
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

all open workbooks
 

Don't feel stupid. You have a lot of company. Otto
"Filips Benoit" wrote in message
...
Thanks,

How stupid of me that i forgot this !

Filip

"Otto Moehrbach" wrote in message
...
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
"Filips Benoit" wrote in message
...
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