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
"Filips Benoit" <(E-Mail Removed)> wrote in message
news:5_bHi.108388$(E-Mail Removed)...
> 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
>

Thanks,

How stupid of me that i forgot this !

Filip

"Otto Moehrbach" <(E-Mail Removed)> wrote in message
news:em42yeH%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:5_bHi.108388$(E-Mail Removed)...
>> 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
>>
>
>

Don't feel stupid. You have a lot of company. Otto
"Filips Benoit" <(E-Mail Removed)> wrote in message
news:9ddHi.108482$%(E-Mail Removed)...
> Thanks,
>
> How stupid of me that i forgot this !
>
> Filip
>
> "Otto Moehrbach" <(E-Mail Removed)> wrote in message
> news:em42yeH%(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:5_bHi.108388$(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>