 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / September 2007all 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 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 > Dear All, > [quoted text clipped - 8 lines] > > Filip Thanks, How stupid of me that i forgot this ! Filip > Filips > If you don't already have one, create a Personal.xls file. This is a [quoted text clipped - 13 lines] >> >> Filip Don't feel stupid. You have a lot of company. Otto > Thanks, > [quoted text clipped - 19 lines] >>> >>> Filip |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.