| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Excel.WorkBooks.Open can't open an XML format xls file | Excel Programming | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
| Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming | |||
![Filips Benoit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
